Skip site navigation (1) Skip section navigation (2)

Re: Inconsistent Errors on Row Comparisons

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inconsistent Errors on Row Comparisons
Date: 2009-06-30 17:31:47
Message-ID: 4004417E-6A04-44FE-887E-E638C6180018@kineticode.com (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-06-30 17:39:57
Subject: Re: foreign.h is not installed
Previous:From: Tom LaneDate: 2009-06-30 17:28:09
Subject: Re: Inconsistent Errors on Row Comparisons

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group