Allow an optional alias for the target table to be specified for UPDATE
authorNeil Conway <neilc@samurai.com>
Sun, 22 Jan 2006 05:20:35 +0000 (05:20 +0000)
committerNeil Conway <neilc@samurai.com>
Sun, 22 Jan 2006 05:20:35 +0000 (05:20 +0000)
commit1d763d9107eda2db054d0f7edee4c2e9b55dfacf
tree8493a62bce7056bad829013e2d7abbb89bfa0f2c
parent57a84ca48e8901e77583f0c415f288430f5d66af
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
doc/src/sgml/ref/update.sgml
doc/src/sgml/regress.sgml
src/backend/parser/gram.y
src/backend/parser/parse_clause.c
src/test/regress/expected/delete.out [new file with mode: 0644]
src/test/regress/expected/rowtypes.out
src/test/regress/expected/update.out
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/delete.sql [new file with mode: 0644]
src/test/regress/sql/rowtypes.sql
src/test/regress/sql/update.sql