Re: triggers and plpgsql question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Mathieu Arnold <mat(at)mat(dot)cc>, pgsql-sql(at)postgresql(dot)org
Subject: Re: triggers and plpgsql question
Date: 2002-08-27 22:38:45
Message-ID: 200208271538.45877.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-08-27 23:18:25 Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Previous Message Tom Lane 2002-08-27 22:13:54 Re: IDENT authentication problem