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