Re: dynmic column names inside trigger?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: dynmic column names inside trigger?
Date: 2007-11-23 20:54:06
Message-ID: EA4DE1AB-1307-496E-8B5F-8CFDC58BFFFD@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2007-11-26 08:13:22 Re: dynmic column names inside trigger?
Previous Message Louis-David Mitterrand 2007-11-23 17:06:12 Re: dynmic column names inside trigger?