pgsql-server: Update DELETE FROM: < * Allow DELETE to handle table

Поиск
Список
Период
Сортировка
От momjian@svr1.postgresql.org (Bruce Momjian)
Тема pgsql-server: Update DELETE FROM: < * Allow DELETE to handle table
Дата
Msg-id 20040810173048.16CCE14B2866@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql-server/doc:
        TODO (r1.1325 -> r1.1326)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1325&r2=1.1326)

В списке pgsql-committers по дате отправления:

Предыдущее
От: petere@svr1.postgresql.org (Peter Eisentraut)
Дата:
Сообщение: pgsql-server: Translation update
Следующее
От: momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql-server: Update DELETE FROM TODO info.