switch case not null postgresql code example

Example: ifnull postgres

SELECT coalesce(column, 1)