Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Inconsistent Errors on Row Comparisons
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "David E. Wheeler" <david(at)kineticode(dot)com>
- Cc: pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: Inconsistent Errors on Row Comparisons
- Date: Tue, 30 Jun 2009 13:28:09 -0400
- Message-id: <20321.1246382889@sss.pgh.pa.us> <text/plain>
"David E. Wheeler" <david(at)kineticode(dot)com> writes: > This is what I see. This query: > VALUES (1, 2), (3, 4) EXCEPT VALUES (1, 'foo'), (3, 'bar'); > Throws 42804 DATATYPE MISMATCH. Yeah ... > Meanwhile, this query: > 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 regards, tom lane
- Follow-Ups:
- Re: Inconsistent Errors on Row Comparisons
- From: David E. Wheeler
- Re: Inconsistent Errors on Row Comparisons
- References:
- Inconsistent Errors on Row Comparisons
- From: David E. Wheeler
- Inconsistent Errors on Row Comparisons
- Prev by Date: Re: 8.5 development schedule
- Next by Date: Re: Inconsistent Errors on Row Comparisons
- Previous by thread: Inconsistent Errors on Row Comparisons
- Next by thread: Re: Inconsistent Errors on Row Comparisons
- Indexes: