Bracketed items "[]" have more detail.

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Mon Aug 9 21:39:00 EDT 2004

Last updated:Tue Aug10 11:00:16 EDT 2004

The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org.

The use of C-style backslashes (.e.g. \n, \r) in quoted strings is not

SQL-spec compliant, so allow such handling to be disabled.

* Allow DELETE to handle table aliases for self-joins [delete]

* Allow DELETE to handle table aliases for self-joins

There is no way tospecify usea table alias for the deleted tablein

the DELETE WHERE clause because thereisno FROM clause. Various

syntax extensionstoadd a FROM clause have been discussed. UPDATE

already has such an optional FROM clause.

There is no way tocreatea table alias for the deleted tablefor use

inthe DELETE WHERE clause. The agreed approachisto allow a USING

clausetospecify additional tables. UPDATE already has an optional

FROM clause for this purpose.

* Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT

* Allow REINDEX to rebuild all database indexes, remove /contrib/reindex