By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.27 |
CREATE TABLE table1(a INTEGER, b INTEGER, c INTEGER);
INSERT INTO table1 VALUES
(1,1,1),
(1,1,2),
(1,1,3),
(1,2,1),
(1,2,2),
(1,2,3),
(1,3,1),
(1,3,2),
(1,3,3);
SELECT *
FROM (VALUES ROW(1),ROW(2))l
| column_0 |
|---|
| 1 |
| 2 |
SELECT *
FROM table1
CROSS JOIN (VALUES ROW(1),ROW(2))x
| a | b | c | column_0 |
|---|---|---|---|
| 1 | 1 | 1 | 2 |
| 1 | 1 | 1 | 1 |
| 1 | 1 | 2 | 2 |
| 1 | 1 | 2 | 1 |
| 1 | 1 | 3 | 2 |
| 1 | 1 | 3 | 1 |
| 1 | 2 | 1 | 2 |
| 1 | 2 | 1 | 1 |
| 1 | 2 | 2 | 2 |
| 1 | 2 | 2 | 1 |
| 1 | 2 | 3 | 2 |
| 1 | 2 | 3 | 1 |
| 1 | 3 | 1 | 2 |
| 1 | 3 | 1 | 1 |
| 1 | 3 | 2 | 2 |
| 1 | 3 | 2 | 1 |
| 1 | 3 | 3 | 2 |
| 1 | 3 | 3 | 1 |