Re: 8.4 RC1 union/nested select cast bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Miller <eric_g_miller(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.4 RC1 union/nested select cast bug?
Date: 2009-06-26 00:50:02
Message-ID: 19492.1245977402@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Eric Miller <eric_g_miller(at)yahoo(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeremy Kerr 2009-06-26 02:18:58 Re: [PATCH] backend: compare word-at-a-time in bcTruelen
Previous Message Eric Miller 2009-06-25 23:44:05 8.4 RC1 union/nested select cast bug?