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`
If you include something like the following people are going to be more willing to provide help and better able to provide good help.
WITH dt (funding_date, actual_date) AS (
VALUES (null, null), ('X', 'X'),
(null, ''), (null, 'X'),
('', null), ('X', null)
)
SELECT funding_date, actual_date,
CASE WHEN funding_date IS NULL
AND actual_date IS NULL
THEN 'Both Null'
ELSE 'write more WHEN statements...'
END
FROM dt
;
That's a self-contained example and it does wonders for problem solving.
David J.
