dudedoe01 schrieb am 27.09.2016 um 19:04: > 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`, > Unrelated, but: why are you storing DATEs in VARCHAR columns? A migration might be a good moment to clean up the data model and store DATEs in a DATE (or TIMESTAMP) column. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
