Re: trigger examples - Mailing list pgsql-sql

From Carolyn Lu Wong
Subject Re: trigger examples
Date
Msg-id 39D98534.31BC8197@kss.net.au
Whole thread Raw
In response to trigger examples  (Carolyn Lu Wong <carolyn@kss.net.au>)
Responses Re: trigger examples
List pgsql-sql
drfrog@smartt.com wrote:
> 
> Carolyn Lu Wong wrote:
> >
> > I need to write a trigger to create a new record in log table if it's a
> > new record or if column A and B changes. Can someone give me an example
> > how to do this.
> >
> > Are there any sites that gives trigger examples??
> >
> > Thanks.
> 
> the fulltextindex in the contrib dir gives an example

The example uses C. Is it possible to create the trigger with plpsql
function?


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Something I'd like to try...
Next
From: Marcin Mazurek
Date:
Subject: grant select on ALL(?) to dbuser;