git.postgresql.org Git - users/andresfreund/postgres.git/commit

projects / users / andresfreund / postgres.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: 57a84ca) | patch

author	Neil Conway <neilc@samurai.com>
	Sun, 22 Jan 2006 05:20:35 +0000 (05:20 +0000)
committer	Neil Conway <neilc@samurai.com>
	Sun, 22 Jan 2006 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

Andres' PG stuff