Horton

Re: (PATCH) Adding CORRESPONDING (NULL error)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kerem Kat <keremkat@gmail.com>
Cc: Erik Rijkers <er@xs4all.nl>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-10-27T19:55:57Z
Lists: pgsql-hackers 
Kerem Kat <keremkat@gmail.com> writes:
> Union with NULL error persists without the corresponding patch. Here
> is the output from postgres without the patch:

> SELECT a FROM (SELECT 1 a) foo
> UNION
> SELECT a FROM (SELECT NULL a) foo2;

> ERROR:  failed to find conversion function from unknown to integer

Yeah, this is a longstanding issue that is not simple to fix without
introducing other unpleasantnesses.  It is not something you should
try to deal with at the same time as implementing CORRESPONDING.

			regards, tom lane