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