NULLIFZERO
Evaluates to NULL if the value in the column is 0.
Syntax
NULLIFZERO(expression)
Parameters
expression |
(INTEGER, DOUBLE PRECISION, INTERVAL, or NUMERIC) Is the string to evaluate for 0 values. |
Example
The TESTING table below shows the test scores for 5 students. Note that test scores are missing for S. Robinson and K. Johnson (NULL values appear in the Score column.)
=> SELECT * FROM TESTING; Name | Score -------------+------- J. Doe | 100 R. Smith | 87 L. White | 0 S. Robinson | K. Johnson | (5 rows)
The SELECT statement below specifies that Vertica should return any 0 values in the Score column as Null. In the results, you can see that Vertica returns L. White's 0 score as Null.
=> SELECT Name, NULLIFZERO(Score) FROM TESTING; Name | NULLIFZERO -------------+------------ J. Doe | 100 R. Smith | 87 L. White | S. Robinson | K. Johnson | (5 rows)