CODE EXAMPLE FOR SQL

plpgsql coalesce equivalent for empty string

COALESCE( NULLIF(col1,'') ,'none');