X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 669FAD1B554 for ; Thu, 13 Nov 2003 17:20:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87872-03 for ; Thu, 13 Nov 2003 13:19:46 -0400 (AST) Received: from dyatel.antar.bryansk.ru (unknown [195.239.214.85]) by svr1.postgresql.org (Postfix) with ESMTP id 9CC89D1B55E for ; Thu, 13 Nov 2003 13:19:45 -0400 (AST) Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.24; FreeBSD) id 1AKL8D-000GHd-9t; Thu, 13 Nov 2003 20:19:45 +0300 Date: Thu, 13 Nov 2003 20:19:45 +0300 From: "Alexander M. Pravking" To: Richard Huxton Cc: pgsql-sql@postgresql.org Subject: Re: STRICT function returning a composite type Message-ID: <20031113171945.GM69653@dyatel.antar.bryansk.ru> References: <20031113160800.GL69653@dyatel.antar.bryansk.ru> <200311131714.27192.dev@archonet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <200311131714.27192.dev@archonet.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/157 X-Sequence-Number: 15972 On Thu, Nov 13, 2003 at 05:14:27PM +0000, Richard Huxton wrote: > RETURNS NULL ON NULL INPUT or STRICT indicates that the function always > returns NULL whenever any of its arguments are NULL. If this parameter is > specified, the function is not executed when there are NULL arguments; > instead a NULL result is assumed automatically. Does "NULL result" mean an empty rowset if the function returns a record? -- Fduch M. Pravking