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

From dudedoe01
Subject Re: isnull() function in pgAdmin3
Date
Msg-id 1475501949339-5924161.post@n3.nabble.com
Whole thread Raw
In response to Re: isnull() function in pgAdmin3  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: isnull() function in pgAdmin3  (Ken Tanzer <ken.tanzer@gmail.com>)
Re: isnull() function in pgAdmin3  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: isnull() function in pgAdmin3  (Raymond O'Donnell <rod@iol.ie>)
Re: isnull() function in pgAdmin3  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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` = '')))
            then
                'RPG_INV'
            when
                ((isnull(`s`.`Funding_Date`)
                    or (`s`.`Funding_Date` <> ''))
                    and ((`s`.`Actual_Close_Date` = '')
                    or isnull(`s`.`Actual_Close_Date`)))
            then
                'Builder_Inventory'
            else 'Owner_Inventory'
        end) AS `Lot_Status`



--
View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5924161.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: otar shavadze
Date:
Subject: Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file
Next
From: Edson Richter
Date:
Subject: Installing pgAdmin 4 in Oracle Enterprise Linux 7