summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2004-08-10 17:30:47 +0000
committerBruce Momjian2004-08-10 17:30:47 +0000
commitf7667e4cfaaed99d26bc4200fa98b2885e29080e (patch)
tree70b09f200b936da3e27678bd1f181376e4dbb73d
parent2c29664b6bfefa8f7a4cc994c92fcb53a2a17962 (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/TODO15
1 files changed, 9 insertions, 6 deletions
diff --git a/doc/TODO b/doc/TODO
index 1c29f9cb156..daf84ba00ef 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -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