1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
-- 3 rows of 1 column
VALUES (1), (2), (3);
-- 3 rows of 1 column
VALUES 1, 2, 3;
-- 1 row of 3 columns
VALUES (1, 2, 3);
-- 3 rows of 2 columns
VALUES (1, 21), (2, 22), (3, 23);
-- nested bracketed values
VALUES ('A', ('S')), ('C', 'X');
-- values with sets
VALUES 1, 2
EXCEPT
VALUES 2;
-- post order by
VALUES 1, 2, 3
ORDER BY 1
OFFSET 1 ROWS
FETCH FIRST 1 ROWS ONLY;
-- values use within a CTE
WITH CTE1 (C) AS (
VALUES 'A', 'B'
)
SELECT *
FROM CTE1;
-- values use within a lateral join
SELECT
X.NUM,
D.MY_COL
FROM MY_SCHEMA.MY_TABLE AS D
CROSS JOIN LATERAL(VALUES 0, 1) AS X (NUM);
-- values within an insert statement
INSERT INTO MY_TAB_DFLT
VALUES
(1, 2, 3),
(1, NULL, DEFAULT);
INSERT INTO MY_TAB_DFLT
VALUES DEFAULT;
INSERT INTO MY_TAB_DFLT
VALUES (DEFAULT);
INSERT INTO MY_TAB_DFLT
VALUES DEFAULT, NULL, 1;
INSERT INTO MY_TAB_DFLT
VALUES (DEFAULT), (NULL), (1);
|
