Thx it helps. Shame on me %) I forgot that NULL itself has no type, and thought that each constant in the view are casted to the resulting type at the creation time. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, August 20, 2008 4:54 PM To: Sergey Hripchenko Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] pgsql do not handle NULL constants in the view Sergey Hripchenko <shripchenko@xxxxxxxxxxxxxx> writes: > CREATE OR REPLACE VIEW bar AS > SELECT * > FROM ( > ( > SELECT calldate, duration, billsec, get_asterisk_cdr_caller_id(accountcode) AS caller_id > FROM asterisk_cdr > ) UNION ALL ( > SELECT start_time, get_interval_seconds(completed_time-start_time), get_interval_seconds(answered_time-start_time), NULL > FROM asterisk_huntgroups_calls > ) > ) AS foo; Try casting the NULL to integer (or whatever the datatype of the other union arm is) explicitly. regards, tom lane This message (including attachments) is private and confidential. If you have received this message in error, please notify us and remove it from your system.
