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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: be2f825) | patch
Add a "USING" clause to DELETE, which is equivalent to the FROM clause
Thu, 7 Apr 2005 01:51:41 +0000 (01:51 +0000)
Thu, 7 Apr 2005 01:51:41 +0000 (01:51 +0000)
commit f5ab0a14ea83eb6c27196b0c5d600b7f8b8b75fc
Add a "USING" clause to DELETE, which is equivalent to the FROM clause
in UPDATE. We also now issue a NOTICE if a query has _any_ implicit
range table entries -- in the past, we would only warn about implicit
RTEs in SELECTs with at least one explicit RTE.

As a result of the warning change, 25 of the regression tests had to
be updated. I also took the opportunity to remove some bogus whitespace
differences between some of the float4 and float8 variants. I believe
I have correctly updated all the platform-specific variants, but let
me know if that's not the case.

Original patch for DELETE ... USING from Euler Taveira de Oliveira,
reworked by Neil Conway.
68 files changed:
doc/src/sgml/ref/delete.sgml diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/equalfuncs.c diff | blob | blame | history
src/backend/parser/analyze.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/parser/parse_relation.c diff | blob | blame | history
src/backend/utils/adt/ruleutils.c diff | blob | blame | history
src/bin/psql/tab-complete.c diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/test/regress/expected/abstime.out diff | blob | blame | history
src/test/regress/expected/boolean.out diff | blob | blame | history
src/test/regress/expected/box.out diff | blob | blame | history
src/test/regress/expected/char.out diff | blob | blame | history
src/test/regress/expected/char_1.out diff | blob | blame | history
src/test/regress/expected/create_misc.out diff | blob | blame | history
src/test/regress/expected/create_view.out diff | blob | blame | history
src/test/regress/expected/float4-exp-three-digits.out diff | blob | blame | history
src/test/regress/expected/float4.out diff | blob | blame | history
src/test/regress/expected/float8-exp-three-digits-win32.out diff | blob | blame | history
src/test/regress/expected/float8-exp-three-digits.out diff | blob | blame | history
src/test/regress/expected/float8-small-is-zero.out diff | blob | blame | history
src/test/regress/expected/float8-small-is-zero_1.out diff | blob | blame | history
src/test/regress/expected/float8.out diff | blob | blame | history
src/test/regress/expected/hash_index.out diff | blob | blame | history
src/test/regress/expected/horology.out diff | blob | blame | history
src/test/regress/expected/int2.out diff | blob | blame | history
src/test/regress/expected/int4.out diff | blob | blame | history
src/test/regress/expected/interval.out diff | blob | blame | history
src/test/regress/expected/join.out diff | blob | blame | history
src/test/regress/expected/join_1.out diff | blob | blame | history
src/test/regress/expected/name.out diff | blob | blame | history
src/test/regress/expected/oid.out diff | blob | blame | history
src/test/regress/expected/point.out diff | blob | blame | history
src/test/regress/expected/polygon.out diff | blob | blame | history
src/test/regress/expected/privileges.out diff | blob | blame | history
src/test/regress/expected/reltime.out diff | blob | blame | history
src/test/regress/expected/rules.out diff | blob | blame | history
src/test/regress/expected/select.out diff | blob | blame | history
src/test/regress/expected/tinterval.out diff | blob | blame | history
src/test/regress/expected/transactions.out diff | blob | blame | history
src/test/regress/expected/varchar.out diff | blob | blame | history
src/test/regress/expected/varchar_1.out diff | blob | blame | history
src/test/regress/input/misc.source diff | blob | blame | history
src/test/regress/sql/abstime.sql diff | blob | blame | history
src/test/regress/sql/boolean.sql diff | blob | blame | history
src/test/regress/sql/box.sql diff | blob | blame | history
src/test/regress/sql/char.sql diff | blob | blame | history
src/test/regress/sql/create_misc.sql diff | blob | blame | history
src/test/regress/sql/create_view.sql diff | blob | blame | history
src/test/regress/sql/float4.sql diff | blob | blame | history
src/test/regress/sql/float8.sql diff | blob | blame | history
src/test/regress/sql/hash_index.sql diff | blob | blame | history
src/test/regress/sql/horology.sql diff | blob | blame | history
src/test/regress/sql/int2.sql diff | blob | blame | history
src/test/regress/sql/int4.sql diff | blob | blame | history
src/test/regress/sql/interval.sql diff | blob | blame | history
src/test/regress/sql/join.sql diff | blob | blame | history
src/test/regress/sql/name.sql diff | blob | blame | history
src/test/regress/sql/oid.sql diff | blob | blame | history
src/test/regress/sql/point.sql diff | blob | blame | history
src/test/regress/sql/polygon.sql diff | blob | blame | history
src/test/regress/sql/privileges.sql diff | blob | blame | history
src/test/regress/sql/reltime.sql diff | blob | blame | history
src/test/regress/sql/rules.sql diff | blob | blame | history
src/test/regress/sql/select.sql diff | blob | blame | history
src/test/regress/sql/tinterval.sql diff | blob | blame | history
src/test/regress/sql/transactions.sql diff | blob | blame | history
src/test/regress/sql/varchar.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /