Skip to content

Commit 2c29664

Browse files
committed
Update DELETE FROM TODO info.
1 parent fdcad61 commit 2c29664

File tree

2 files changed

+6
-1361
lines changed

2 files changed

+6
-1361
lines changed

doc/TODO

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ TODO list for PostgreSQL
55
Bracketed items "[]" have more detail.
66

77
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
8-
Last updated: Mon Aug 9 21:39:00 EDT 2004
8+
Last updated: Tue Aug 10 11:00:16 EDT 2004
99

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

@@ -271,12 +271,12 @@ Commands
271271
The use of C-style backslashes (.e.g. \n, \r) in quoted strings is not
272272
SQL-spec compliant, so allow such handling to be disabled.
273273

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

276-
There is no way to specify use a table alias for the deleted table in
277-
the DELETE WHERE clause because there is no FROM clause. Various
278-
syntax extensions to add a FROM clause have been discussed. UPDATE
279-
already has such an optional FROM clause.
276+
There is no way to create a table alias for the deleted table for use
277+
in the DELETE WHERE clause. The agreed approach is to allow a USING
278+
clause to specify additional tables. UPDATE already has an optional
279+
FROM clause for this purpose.
280280

281281
* Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
282282
* Allow REINDEX to rebuild all database indexes, remove /contrib/reindex

0 commit comments

Comments
 (0)