IFNULL

Returns the value of the first non-null expression in the list.

IFNULL is an alias of NVL.

Behavior Type

Immutable

Syntax

IFNULL ( expression1 , expression2 );

Parameters

Notes

Examples

=> SELECT IFNULL (SCORE, 0.0) FROM TESTING;
 IFNULL
--------
  100.0
   87.0
     .0
     .0
     .0
(5 rows)