NULL is a reserved keyword used to indicate that a data value is unknown. It is the ASCII abbreviation for NULL characters (
Usage in Expressions
Vertica does not treat an empty string as a NULL value. An expression must specify NULL to indicate that a column value is unknown.
The following considerations apply to using NULL in expressions:
- NULL is not greater than, less than, equal to, or not equal to any other expression. Use the Boolean predicate to determine whether an expression value is NULL.
- You can write queries with expressions that contain the
NULL=NULLjoins. See Equi-Joins and Non Equi-Joins in Analyzing Data.
- Vertica accepts NULL characters (
'\0') in constant strings and does not remove null characters from VARCHAR fields on input or output.
Projection Ordering of NULL Data
Vertica sorts NULL values in projection columns as follows:
|Column data type||NULL values placed at...|
|Beginning of sorted column (
|End of sorted column (