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

On Tue, Sep 27, 2016 at 12:04 PM, dudedoe01 <marsalanaq@gmail.com> wrote:

> I am trying to emulate the isnull() function used in MySQL into postreSQL.

In the future, please describe the results you are trying to achieve
or at least describe the semantics of the function from elsewhere that
you are trying to emulate.  I had no idea what the ISNLL() function of
MySQL does; on a quick web search, it looks like you can replace:
  isnull(expression)

with:

  (expression) IS NULL


> In MySQL:
>
> (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`,

In PostgreSQL perhaps:

(case
            when
                (("s"."Funding_Date" = '')
                    and (("s"."Actual_Close_Date") is null
                    or ("s"."Actual_Close_Date" = '')))
            then
                'RPG_INV'
            when
                ((("s"."Funding_Date") is null
                    or ("s"."Funding_Date" <> ''))
                    and (("s"."Actual_Close_Date" = '')
                    or ("s"."Actual_Close_Date") is null))
            then
                'Builder_Inventory'
            else 'Owner_Inventory'
        end) AS "Lot_Status",

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company