Skip site navigation (1) Skip section navigation (2)

Re: Tantalizing reference to passing data from NEW variable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Rich Cullingford <rculling(at)sysd(dot)com>,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Tantalizing reference to passing data from NEW variable
Date: 2004-04-28 05:09:14
Message-ID: 23420.1083128954@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Joe Conway <mail(at)joeconway(dot)com> writes:
> Rich Cullingford wrote:
>> This question seems to have been asked a number of times on this list, 
>> recently (including by me) without being answered: how to pass the row 
>> data stored in the NEW variable from a trigger function into a 
>> sub-function.

> I looked a bit at making this work in PL/pgSQL at some point -- IIRC the
> issues to be solved were non-trivial.

I think that this might be less non-trivial given the recent changes in
the composite-type-datum support.  I haven't got round to looking at
plpgsql in particular, though.

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: Philippe Sempé Date: 2004-04-29 12:54:26
Subject: Socket command type unknown
Previous:From: Lee KindnessDate: 2004-04-27 16:17:18
Subject: Re: Application compile file using Embeded SQL in P

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group