DELETE Without Predicate is Not Supported

[Padraig O'Sullivan]

server revision: 1824

employees=> create table t1(id int not null primary key);
CREATE TABLE
employees=> insert into t1 values (1), (2), (3);
INSERT 0 3
employees=> select * from t1;
 id
----
  1
  2
  3
(3 rows)

employees=> delete from t1;
ERROR: Encountered " ";" "; "" at line 1, column 15.
Was expecting one of:
    "as" ...
    <IDENTIFIER> ...
    <BACKQUOTED_IDENTIFIER> ...
    <DOUBLEQUOTED_IDENTIFIER> ...

LINE 1: delete from t1;
                      ^
employees=> delete from t1 where 1=1;
DELETE 3
employees=> select * from t1;
 id
----
(0 rows)

employees=>

Since TRUNCATE is not supported would be nice to able to easily delete all data from the table (unless we want to add support for TRUNCATE which would be nicer).

[Timothy Wegner (timmwegner)]

Proserv feels this is not an urgent requirement so set the priority to moderate and marked for a future release.

[Nathan Williams (nwilliams)]

Note: TRUNCATE is now supported.