Re: triggers and plpgsql question

From: Mathieu Arnold <mat(at)mat(dot)cc>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: triggers and plpgsql question
Date: 2002-08-28 06:42:13
Message-ID: 169617531.1030524133@sauron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--On mardi 27 août 2002 15:38 -0700 Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gaetano Mendola 2002-08-28 07:30:13 unsubscribe
Previous Message Tom Lane 2002-08-28 04:29:16 Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?