summaryrefslogtreecommitdiff
path: root/src/test/parser/input/delete.sql
blob: f2c63b1c30733067898e18b39985fbe174347e75 (plain)
1
2
3
4
5
6
7
8
9
10
DELETE FROM t;
DELETE ;
DELETE FROM ONLY xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;
DELETE FROM t WHERE x = 3;
DELETE FROM t WHERE x IN (select * from t1);
DELETE FROM foo WHERE a = 1 RETURNING *;
DELETE FROM foo WHERE a = 1 RETURNING a;
DELETE FROM foo WHERE a = 1 RETURNING a,b;
DELETE FROM foo WHERE CURRENT OF $1
DELETE FROM foo WHERE CURRENT OF cur