Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example:
nullif(city,'other')


COALESCE
coalesce(T v1, T v2, ...) - Returns the first v that is not NULL, or NULL if all v's are NULL. Max number of params: 20.

Example:
coalesce(NULL, 'a')