NULL value in subselect in UNION causes error - Mailing list pgsql-hackers

From Jan Wieck
Subject NULL value in subselect in UNION causes error
Date
Msg-id 45BA5D7D.8040608@Yahoo.com
Whole thread Raw
Responses Re: NULL value in subselect in UNION causes error
List pgsql-hackers
Checked it against HEAD and 8.2:

postgres=# select 1, 1, 1 union select * from (select 2, null, 2) two;
ERROR:  failed to find conversion function from "unknown" to integer


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: Piggybacking vacuum I/O
Next
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] Autovacuum Improvements