Postgres Pro
Downloads
Home   >   mailing lists

Re: isnull() function in pgAdmin3 - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: isnull() function in pgAdmin3
Date
Msg-id 411c032f-dfd8-f4a3-b141-e0222ebb1371@iol.ie
Whole thread Raw
In response to Re: isnull() function in pgAdmin3  (dudedoe01 <marsalanaq@gmail.com>)
List pgsql-general
Tree view 
On 03/10/16 14:39, dudedoe01 wrote:
> What is the most feasible way to emulate the below MySQL function into
> postgreSQL. Since the isnull() function is no longer supported in 9.6
> version. I have tried every trick in the hat to get the desired results.
> Still 'RPG INV' doesn't show only the other two then options show up.
>
> (case
>             when
>                 ((`s`.`Funding_Date` = '')
>                     and (isnull(`s`.`Actual_Close_Date`)
>                     or (`s`.`Actual_Close_Date` = '')))

<snip>

Maybe I missed something earlier in the thread (only tuned in now), but
what's wrong with

    ... and s.actual_close_date is null ....

?

Ray.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: isnull() function in pgAdmin3
Next
From: otar shavadze
Date:
Subject: Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file