Re: sql functions and triggers

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Andrzej Roszkowski <andrzej(dot)roszkowski(at)polcard(dot)com(dot)pl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: sql functions and triggers
Date: 2001-03-07 14:28:29
Message-ID: 20010307152829.B19065@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Mar 07, 2001 at 03:03:59PM +0100, Andrzej Roszkowski wrote:
> Hello!
>
> It is possible to pass ie. insert fields and values to sql function in
> trigger? I want to define a trigger on insert (select delete etc.) and log
> some values in different table(s).

Sure, see docs about SPI interface or you can try use RULEs for this.

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Boulat Khakimov 2001-03-07 15:19:44 Re: (blowfish in Postgres) Undefined symbol -- YAY!
Previous Message Salvador Mainé 2001-03-07 14:23:23 SQL problem