Re: triggers and plpgsql question - Mailing list pgsql-sql

From Mathieu Arnold
Subject Re: triggers and plpgsql question
Date
Msg-id 169617531.1030524133@sauron
Whole thread Raw
In response to Re: triggers and plpgsql question  (Josh Berkus <josh@agliodbs.com>)
Responses Re: triggers and plpgsql question
List pgsql-sql

--On mardi 27 août 2002 15:38 -0700 Josh Berkus <josh@agliodbs.com> wrote:

>
> Mathieu,
>
>> The thing I need, is to be able to know what does NEW contains, and I
>> have not found out any mean to do so. If it's not possible to do so,
>> I'll write a function per table, but for the beauty of all this, I would
>> have liked to do it the way above.
>
> You can't do this in PL/pgSQL.   See the online documentation on writing
> triggers in C; that is the only way to get what you want.

So, if I want to avoid C, I'll have to write a function per table. I'll
have a look at SPI (as I believe after a short readout of the doc, I'll
need it).

--
Mathieu Arnold


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Calculation Error on Epoch?
Next
From: "Gaetano Mendola"
Date:
Subject: unsubscribe