Re: pgsql do not handle NULL constants in the view

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
resultingtype at the creation time. 

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, August 20, 2008 4:54 PM
To: Sergey Hripchenko
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] pgsql do not handle NULL constants in the view

Sergey Hripchenko <shripchenko@intermedia.net> 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
notifyus and remove it from your system.