author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 16 Jun 2020 16:42:34 +0300 | |
changeset 2422 | 242e08fa2c73 |
parent 2421 | 07304e8a9820 |
child 2423 | 6a4fd5ccb340 |
postgres.rst | file | annotate | diff | comparison | revisions |
--- a/postgres.rst Tue Jun 16 14:44:06 2020 +0300 +++ b/postgres.rst Tue Jun 16 16:42:34 2020 +0300 @@ -649,3 +649,9 @@ WITH t AS (SELECT val FROM generate_series(1, 10) val) SELECT * FROM t; + WITH + seq1(num) AS (VALUES (1), (2), (3)), + seq2(str) AS (VALUES ('a'), ('b'), ('c')) + SELECT * FROM seq1 + CROSS JOIN seq2; +