Functions / Comparison Functions And Operators

num_nonnulls

Returns the number of non-null arguments.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

Signatures & examples

num_nonnulls ( VARIADIC "any" ) → integer

Returns the number of non-null arguments.

num_nonnulls(1, NULL, 2) → 2

Version history 2

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source