Add num_nulls() and num_nonnulls() to count NULL arguments.
Tom Lane <tgl@sss.pgh.pa.us>
Add num_nulls() and num_nonnulls() to count NULL arguments. An example use-case is "CHECK(num_nonnulls(a,b,c) = 1)" to assert that exactly one of a,b,c isn't NULL. The functions are variadic, so they can also be pressed into service to count the number of null or nonnull elements in an array. Marko Tiikkaja, reviewed by Pavel Stehule
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +48 −5 |
| src/backend/utils/adt/misc.c | modified | +121 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +6 −0 |
| src/include/utils/builtins.h | modified | +3 −1 |
| src/test/regress/expected/misc_functions.out | added | +135 −0 |
| src/test/regress/parallel_schedule | modified | +1 −1 |
| src/test/regress/serial_schedule | modified | +1 −0 |
| src/test/regress/sql/misc_functions.sql | added | +31 −0 |