pgsql: Allow an optional alias for the target table to be specified for

Поиск
Список
Период
Сортировка
От neilc@postgresql.org (Neil Conway)
Тема pgsql: Allow an optional alias for the target table to be specified for
Дата
Msg-id 20060122052035.646579DC82C@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Allow an optional alias for the target table to be specified for UPDATE
and DELETE. If specified, the alias must be used instead of the full
table name. Also, the alias currently cannot be used in the SET clause
of UPDATE.

Patch from Atsushi Ogawa, various editorialization by Neil Conway.
Along the way, make the rowtypes regression test pass if add_missing_from
is enabled, and add a new (skeletal) regression test for DELETE.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        regress.sgml (r1.49 -> r1.50)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/regress.sgml.diff?r1=1.49&r2=1.50)
    pgsql/doc/src/sgml/ref:
        delete.sgml (r1.25 -> r1.26)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/delete.sgml.diff?r1=1.25&r2=1.26)
        update.sgml (r1.34 -> r1.35)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/update.sgml.diff?r1=1.34&r2=1.35)
    pgsql/src/backend/parser:
        gram.y (r2.522 -> r2.523)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.522&r2=2.523)
        parse_clause.c (r1.144 -> r1.145)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_clause.c.diff?r1=1.144&r2=1.145)
    pgsql/src/test/regress:
        parallel_schedule (r1.30 -> r1.31)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/parallel_schedule.diff?r1=1.30&r2=1.31)
        serial_schedule (r1.29 -> r1.30)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/serial_schedule.diff?r1=1.29&r2=1.30)
    pgsql/src/test/regress/expected:
        rowtypes.out (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rowtypes.out.diff?r1=1.5&r2=1.6)
        update.out (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/update.out.diff?r1=1.1&r2=1.2)
    pgsql/src/test/regress/sql:
        rowtypes.sql (r1.4 -> r1.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/rowtypes.sql.diff?r1=1.4&r2=1.5)
        update.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/update.sql.diff?r1=1.2&r2=1.3)

Added Files:
-----------
    pgsql/src/test/regress/expected:
        delete.out (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/delete.out?rev=1.1&content-type=text/x-cvsweb-markup)
    pgsql/src/test/regress/sql:
        delete.sql (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/delete.sql?rev=1.1&content-type=text/x-cvsweb-markup)

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

Предыдущее
От: neilc@postgresql.org (Neil Conway)
Дата:
Сообщение: pgsql: Minor improvements to GEQO documentation.
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Fix alias-for-target-table-of-UPDATE-or-DELETE patch so that