Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 RC1 union/nested select cast bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4 RC1 union/nested select cast bug?
Date
Msg-id 19492.1245977402@sss.pgh.pa.us
Whole thread Raw
In response to 8.4 RC1 union/nested select cast bug?  (Eric Miller <eric_g_miller@yahoo.com>)
List pgsql-hackers
Tree view 
Eric Miller <eric_g_miller@yahoo.com> writes:
> With 8.4RC1, I get the following error with the SQL below.
> ERROR: failed to find conversion function from unknown to character varying

Every PG version since 7.1 complains about that query, because it's
underspecified.  Cast the NULL to something specific in the sub-SELECT.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Eric Miller
Date:
Subject: 8.4 RC1 union/nested select cast bug?
Next
From: Jeremy Kerr
Date:
Subject: Re: [PATCH] backend: compare word-at-a-time in bcTruelen