On Jun 30, 2009, at 10:28 AM, Tom Lane wrote:
VALUES (1, 2), (3, 4) EXCEPT VALUES (1), (3);
Throws 42601 SYNTAX ERROR.
Not for me:
regression=# VALUES (1, 2), (3, 4) EXCEPT VALUES (1), (3);
ERROR: each EXCEPT query must have the same number of columns
Turn on verbosity:
try=# \set VERBOSITY verbose
try=# VALUES (1, 2), (3, 4) EXCEPT VALUES (1), (3);
ERROR: 42601: each EXCEPT query must have the same number of columns
LOCATION: transformSetOperationTree, analyze.c:1502
42601 is a SYNTAX ERROR.
The inconsistency when comparing records from cursors stands, too.
Best,
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers