If we try to apply the ISNULL function in Snowflake, it will not work: SET val=NULL; SELECT ISNULL($val, 0) as VAL; As we can see, we received an error message clearly mentioning that ISNULL is an unknown funct
How to Use nullif() in PostgreSQL The nullif() function returns a null value, if a the value of the field/column defined by the first parameter equals that of the second. Otherwise, it will return the original value. Here's an example below: ...