aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2010-02-14 00:48:12 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2010-02-14 00:48:12 +0000
commita9aad1b8687f9919cdf7792c3a04ebc7239fe8f1 (patch)
treec66fbcea5d3d9bc9610463fed09b3b74876b8534
parentbbdf72b095f646c85b572677376692a47924e3fc (diff)
downloadpostgresql-a9aad1b8687f9919cdf7792c3a04ebc7239fe8f1.tar.gz
postgresql-a9aad1b8687f9919cdf7792c3a04ebc7239fe8f1.zip
Document the behavior of STRICT VARIADIC functions.
-rw-r--r--doc/src/sgml/ref/create_function.sgml9
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml
index 6d7eb84d8f2..41dc4365ce7 100644
--- a/doc/src/sgml/ref/create_function.sgml
+++ b/doc/src/sgml/ref/create_function.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.88 2009/10/08 02:39:14 tgl Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.89 2010/02/14 00:48:12 tgl Exp $
-->
<refentry id="SQL-CREATEFUNCTION">
@@ -585,6 +585,13 @@ CREATE FUNCTION foo(int, int default 42) ...
existing calls of the function do not stop working when it is replaced.
</para>
+ <para>
+ If a function is declared <literal>STRICT</> with a <literal>VARIADIC</>
+ argument, the strictness check tests that the variadic array <emphasis>as
+ a whole</> is non-null. The function will still be called if the
+ array has non-null elements.
+ </para>
+
</refsect1>
<refsect1 id="sql-createfunction-examples">