diff options
author | Bruce Momjian | 2004-08-10 17:30:47 +0000 |
---|---|---|
committer | Bruce Momjian | 2004-08-10 17:30:47 +0000 |
commit | f7667e4cfaaed99d26bc4200fa98b2885e29080e (patch) | |
tree | 70b09f200b936da3e27678bd1f181376e4dbb73d | |
parent | 2c29664b6bfefa8f7a4cc994c92fcb53a2a17962 (diff) |
Update DELETE FROM:
< * Allow DELETE to handle table aliases for self-joins
> * Allow an alias to be provided for the target table in UPDATE/DELETE
276,279c276,282
< There is no way to create a table alias for the deleted table for use
< in the DELETE WHERE clause. The agreed approach is to allow a USING
< clause to specify additional tables. UPDATE already has an optional
< FROM clause for this purpose.
> This is not SQL-spec but many DBMSs allow it.
>
> * Allow additional tables to be specified in DELETE for joins
>
> UPDATE already allows this (UPDATE...FROM) but we need similar
> functionality in DELETE. It's been agreed that the keyword should
> be USING, to avoid anything as confusing as DELETE FROM a FROM b.
-rw-r--r-- | doc/TODO | 15 |
1 files changed, 9 insertions, 6 deletions
@@ -5,7 +5,7 @@ TODO list for PostgreSQL Bracketed items "[]" have more detail. Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Tue Aug 10 11:00:16 EDT 2004 +Last updated: Tue Aug 10 13:30:30 EDT 2004 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -271,12 +271,15 @@ Commands 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 +* Allow an alias to be provided for the target table in UPDATE/DELETE - There is no way to create a table alias for the deleted table for use - in the DELETE WHERE clause. The agreed approach is to allow a USING - clause to specify additional tables. UPDATE already has an optional - FROM clause for this purpose. + This is not SQL-spec but many DBMSs allow it. + +* Allow additional tables to be specified in DELETE for joins + + UPDATE already allows this (UPDATE...FROM) but we need similar + functionality in DELETE. It's been agreed that the keyword should + be USING, to avoid anything as confusing as DELETE FROM a FROM b. * Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT * Allow REINDEX to rebuild all database indexes, remove /contrib/reindex |