Avoid a Division by Zero Error with the NULLIF and NULLIFZERO Functions: Quick Tip
Sarah Lemaire, Manager, Vertica Documentation
July 30, 2018
Jim Knicely authored this tip. The NULLIF built-in Vertica function compares two expressions. If the expressions are not equal, the function returns the first expression. If the expressions are equal, the function returns NULL. The NULLIFZERO built-in Vertica function evaluates to NULL if the value in the column is 0. Both come in handy when...