"David E. Wheeler" <[email protected]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
