# HG changeset patch # User Oleksandr Gavenko # Date 1592314954 -10800 # Node ID 242e08fa2c73019c1d55a74a523486c4aa8f84e2 # Parent 07304e8a9820af3c923bd914e15152b8828cd01e generate table. diff -r 07304e8a9820 -r 242e08fa2c73 postgres.rst --- 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; +