postgresql coalesce empty string code example Example: plpgsql coalesce equivalent for empty string COALESCE( NULLIF(col1,'') ,'none');