-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of dudedoe01 Sent: Tuesday, September 27, 2016 1:05 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: isnull() function in pgAdmin3 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`, __________________________________________________________________________________________________________ isnull(`s`.`Actual_Close_Date`) in MySQL is equivalent to: s.actual_close_date IS NULL in Postgres. What exactly didn't work for you? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
