"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