From f5ab0a14ea83eb6c27196b0c5d600b7f8b8b75fc Mon Sep 17 00:00:00 2001
From: Neil Conway <neilc@samurai.com>
Date: Thu, 7 Apr 2005 01:51:41 +0000
Subject: 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.
---
 src/test/regress/sql/transactions.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/test/regress/sql/transactions.sql')

diff --git a/src/test/regress/sql/transactions.sql b/src/test/regress/sql/transactions.sql
index 6aebfcc867..247d6facb8 100644
--- a/src/test/regress/sql/transactions.sql
+++ b/src/test/regress/sql/transactions.sql
@@ -45,7 +45,7 @@ DROP TABLE writetest; -- fail
 INSERT INTO writetest VALUES (1); -- fail
 SELECT * FROM writetest; -- ok
 DELETE FROM temptest; -- ok
-UPDATE temptest SET a = 0 WHERE a = 1 AND writetest.a = temptest.a; -- ok
+UPDATE temptest SET a = 0 FROM writetest WHERE temptest.a = 1 AND writetest.a = temptest.a; -- ok
 PREPARE test AS UPDATE writetest SET a = 0; -- ok
 EXECUTE test; -- fail
 SELECT * FROM writetest, temptest; -- ok
-- 
cgit v1.2.1

