7 lines
267 B
Text
7 lines
267 B
Text
CREATE OR REPLACE TABLE A AS
|
|
SELECT rowid, N
|
|
FROM (select [1, 3, -5] as l, unnest(l) as N, generate_subscripts(l, 1) AS rowid);
|
|
|
|
CREATE OR REPLACE TABLE B AS
|
|
SELECT rowid, N
|
|
FROM (select [4, -2, -1] as l, unnest(l) as N, generate_subscripts(l, 1) AS rowid);
|