Re: Inconsistent Errors on Row Comparisons - Mailing list pgsql-hackers

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