git.8kb.co.uk Git - pgpool-ii/pgpool-ii_2.2.5/blob - test/parser/input/delete.sql

   1 DELETE FROM t;
   2 DELETE ;
   3 DELETE FROM ONLY xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;
   4 DELETE FROM t WHERE x = 3;
   5 DELETE FROM t WHERE x IN (select * from t1);
   6 DELETE FROM foo WHERE a = 1 RETURNING *;
   7 DELETE FROM foo WHERE a = 1 RETURNING a;
   8 DELETE FROM foo WHERE a = 1 RETURNING a,b;
   9 DELETE FROM foo WHERE CURRENT OF $1
  10 DELETE FROM foo WHERE CURRENT OF cur