Re: Inconsistent Errors on Row Comparisons

["David E. Wheeler" <david(at)kineticode(dot)com>]

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