summaryrefslogtreecommitdiff
path: root/src/test/parser/input/insert.sql
blob: c48340c7408917158c4ceae24ff78e4d702962b2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
INSERT INTO t values (1);
INSERT INTO t(a) VALUES (2);
INSERT INTO t(a,b,c) VALUES (2,2);
INSERT INTO t(a,b,c) VALUES (2,2,3);
INSERT INTO t(a,b,c) VALUES (2,DEFAULT,'3');
INSERT INTO t DEFAULT VALUES;
INSERT INTO t SELECT  * FROM t;
INSERT INTO t values (func(x, y));
INSERT INTO t(a,b,c) VALUES (2,DEFAULT,'\'\\');
INSERT INTO foo(a,b) VALUES (1, 2) RETURNING *;
INSERT INTO foo(a,b) VALUES (1, 2) RETURNING a;
INSERT INTO foo(a,b) VALUES (1, 2) RETURNING a,b;
INSERT INTO foo(a,b) VALUES (1, 2), (3, 4), (5, 6);