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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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