From: | dudedoe01 <marsalanaq(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | isnull() function in pgAdmin3 |
Date: | 2016-09-27 17:04:31 |
Message-ID: | 1474995871397-5923122.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am trying to emulate the isnull() function used in MySQL into postreSQL. I
have tried different ways such is null but it's not producing the results
desired. I am doing a data migration from MySQL into postgreSQL and need
help with the isnull() in pgAdmin3.
Any assistance provided would be greatly appreciated.
Thanks,
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`,
--
View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-09-27 17:55:45 | Re: Determining server load |
Previous Message | Israel Brewster | 2016-09-27 16:54:32 | Determining server load |