git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Allow an optional alias for the target table to be specified for UPDATE

author Neil Conway <neilc@samurai.com>

2006年1月22日 05:20:35 +0000 (05:20 +0000)

committer Neil Conway <neilc@samurai.com>

2006年1月22日 05:20:35 +0000 (05:20 +0000)

commit 1d763d9107eda2db054d0f7edee4c2e9b55dfacf

tree 8493a62bce7056bad829013e2d7abbb89bfa0f2c tree

parent 57a84ca48e8901e77583f0c415f288430f5d66af commit | diff

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.

13 files changed:

doc/src/sgml/ref/delete.sgml diff | blob | blame | history

doc/src/sgml/ref/update.sgml diff | blob | blame | history

doc/src/sgml/regress.sgml diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/backend/parser/parse_clause.c diff | blob | blame | history

src/test/regress/expected/delete.out [new file with mode: 0644] blob

src/test/regress/expected/rowtypes.out diff | blob | blame | history

src/test/regress/expected/update.out diff | blob | blame | history

src/test/regress/parallel_schedule diff | blob | blame | history

src/test/regress/serial_schedule diff | blob | blame | history

src/test/regress/sql/delete.sql [new file with mode: 0644] blob

src/test/regress/sql/rowtypes.sql diff | blob | blame | history

src/test/regress/sql/update.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom