[SQL] 8.3/8.4 SQL incompatibility?

2009-12-16 Thread Britt Piehler
A generated query of ours broke on upgrade from PG 8.3.3 to 8.4.1 with the following error: ERROR: failed to find conversion function from unknown to character varying SQL state: XX000 I've narrowed it down to sub-selects in union clauses, as in the test script below, which runs successfully on

Re: [SQL] 8.3/8.4 SQL incompatibility?

2009-12-16 Thread Tom Lane
Britt Piehler writes: > A generated query of ours broke on upgrade from PG 8.3.3 to 8.4.1 with > the following error: > ERROR: failed to find conversion function from unknown to character varying Hm. I'm not going to promise that such cases should work always, but given that this particular cas