if zero postgresql code example

Example: postgresql if 0 then 1

-- returns the greatest value, in case 1
select greatest( 0, 1 )
-> 1
-- it also works with null values
select greatest( null, 1 )
-> 1