changeset 2422 | 242e08fa2c73 |
parent 2421 | 07304e8a9820 |
child 2436 | 41f79c1242b2 |
2421:07304e8a9820 | 2422:242e08fa2c73 |
---|---|
647 SELECT val FROM generate_series(1, 10) val; |
647 SELECT val FROM generate_series(1, 10) val; |
648 |
648 |
649 WITH t AS (SELECT val FROM generate_series(1, 10) val) |
649 WITH t AS (SELECT val FROM generate_series(1, 10) val) |
650 SELECT * FROM t; |
650 SELECT * FROM t; |
651 |
651 |
652 WITH |
|
653 seq1(num) AS (VALUES (1), (2), (3)), |
|
654 seq2(str) AS (VALUES ('a'), ('b'), ('c')) |
|
655 SELECT * FROM seq1 |
|
656 CROSS JOIN seq2; |
|
657 |