granicus.if.org Git - postgresql/commit

]> granicus.if.org Git - postgresql/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 5 Feb 2016 04:03:10 +0000 (23:03 -0500)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 5 Feb 2016 04:03:37 +0000 (23:03 -0500)
commit	6819514fca22f8554edcab6e4d0402b0221f03bb
tree	e78c772e621f3f83804d76d024fdbdf80943a7de	tree \| snapshot
parent	d0cd7bda97a626049aa7d247374909c52399c413	commit \| diff

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

doc/src/sgml/func.sgml		diff \| blob \| history
src/backend/utils/adt/misc.c		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/catalog/pg_proc.h		diff \| blob \| history
src/include/utils/builtins.h		diff \| blob \| history
src/test/regress/expected/misc_functions.out	[new file with mode: 0644]	blob
src/test/regress/parallel_schedule		diff \| blob \| history
src/test/regress/serial_schedule		diff \| blob \| history
src/test/regress/sql/misc_functions.sql	[new file with mode: 0644]	blob

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom