postgres if 1 and 0 instead of true and false 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
-- returns the greatest value, in case 1
select greatest( 0, 1 )
-> 1
-- it also works with null values
select greatest( null, 1 )
-> 1