A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct SQL-spec-compliant behavior of expr = NULL is to always return null (unknown).
|Value Range||Default||Set Classifications|