Re: pgsql do not handle NULL constants in the view - Mailing list pgsql-performance

From Tom Lane
Subject Re: pgsql do not handle NULL constants in the view
Date
Msg-id 27257.1219236864@sss.pgh.pa.us
Whole thread Raw
In response to pgsql do not handle NULL constants in the view  (Sergey Hripchenko <shripchenko@intermedia.net>)
Responses Re: pgsql do not handle NULL constants in the view  (Sergey Hripchenko <shripchenko@intermedia.net>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Kranti K K Parisa™"
Date:
Subject: PostgreSQL+Hibernate Performance
Next
From: Sergey Hripchenko
Date:
Subject: Re: pgsql do not handle NULL constants in the view