NULLIF
Returns NULL if two expressions are equal. Otherwise return expr1. They must have the same data type.
Analyze Syntax
func.nullif(<expr1>, <expr2>)
Analyze Examples
func.nullif(0, null)
┌──────────────────────┐
│ func.nullif(0, null) │
├──────────────────────┤
│ 0 │
└──────────────────────┘
SQL Syntax
NULLIF(<expr1>, <expr2>)
SQL Examples
SELECT NULLIF(0, NULL);
┌─────────────────┐
│ nullif(0, null) │
├─────────────────┤
│ 0 │
└─────────────────┘
Last modified April 25, 2024 at 8:41 PM EST: updating conditional functions (c113c0b)