Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 847672E0032 for ; Fri, 23 Nov 2007 16:54:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 39344-09 for ; Fri, 23 Nov 2007 16:54:26 -0400 (AST) Received: from mtai04.charter.net (mtai04.charter.net [209.225.8.184]) by postgresql.org (Postfix) with ESMTP id DA1452E0033 for ; Fri, 23 Nov 2007 16:54:26 -0400 (AST) Received: from aarprv04.charter.net ([10.20.200.74]) by mtai04.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20071123205405.CCBJ10863.mtai04.charter.net@aarprv04.charter.net>; Fri, 23 Nov 2007 15:54:05 -0500 Received: from [10.0.1.4] (really [66.188.156.151]) by aarprv04.charter.net with ESMTP id <20071123205405.UQWM17353.aarprv04.charter.net@[10.0.1.4]>; Fri, 23 Nov 2007 15:54:05 -0500 In-Reply-To: <20071123170611.GA31463@apartia.fr> References: <20071120161258.GA27106@apartia.fr> <4743F6E5.A3DD.0030.0@indicator.be> <20071123170611.GA31463@apartia.fr> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: dynmic column names inside trigger? Date: Fri, 23 Nov 2007 15:54:06 -0500 To: Louis-David Mitterrand X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/128 X-Sequence-Number: 29656 On Nov 23, 2007, at 12:06 , Louis-David Mitterrand wrote: > On Wed, Nov 21, 2007 at 09:14:14AM +0100, Bart Degryse wrote: >> LANGUAGE plpgsql VOLATILE RETURNS NULL ON NULL INPUT; > > Hi, > > I was curious as to why you created this function with a prototype of > > func(intext IN text, outtext OUT text) ... returns NULL Don't confuse RETURNS NULL ON NULL INPUT with the function return value: this is the verbose spelling of STRICT. Michael Glaesemann grzm seespotcode net