Postgres Pro
Downloads
Home   >   mailing lists

Re: sql functions and triggers - Mailing list pgsql-sql

From Karel Zak
Subject Re: sql functions and triggers
Date
Msg-id 20010307152829.B19065@ara.zf.jcu.cz
Whole thread Raw
In response to sql functions and triggers  (Andrzej Roszkowski <andrzej.roszkowski@polcard.com.pl>)
List pgsql-sql
Tree view 
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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz

pgsql-sql by date:

Previous
From: Andrzej Roszkowski
Date:
Subject: sql functions and triggers
Next
From: Josh Berkus
Date:
Subject: Re: No Documentation for to_char(INTERVAL, mask)