Re: [GENERAL] Trigger Function return values

2011-03-22 Thread Adrian Klaver
On Tuesday, March 22, 2011 3:12:56 pm Andy Chambers wrote: > Hi, > > How is the return value of a trigger function defined in plpgsql used? I > can't find > anything in the documentation but some of the examples return NULL, and > others return > something like NEW. > > It seems that if the retu

Re: [GENERAL] Trigger Function return values

2011-03-22 Thread Scott Ribe
On Mar 22, 2011, at 4:12 PM, Andy Chambers wrote: > How is the return value of a trigger function defined in plpgsql used? I > can't find > anything in the documentation but some of the examples return NULL, and > others return > something like NEW.

[GENERAL] Trigger Function return values

2011-03-22 Thread Andy Chambers
Hi, How is the return value of a trigger function defined in plpgsql used? I can't find anything in the documentation but some of the examples return NULL, and others return something like NEW. It seems that if the return statement is omitted, an error occurs when the trigger is fired.