Re: Question about accessing current row data inside trigger - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Question about accessing current row data inside trigger
Date
Msg-id 20050314054746.GA16968@winnie.fuhr.org
Whole thread Raw
In response to Question about accessing current row data inside trigger  (peter Willis <peterw@borstad.com>)
Responses Re: Question about accessing current row data inside trigger
List pgsql-general
On Tue, Mar 08, 2005 at 11:37:14AM -0800, peter Willis wrote:

> I have a trigger function written in C.
> The trigger function is called via:
>
> CREATE TRIGGER after_update AFTER UPDATE ON some_table
>    FOR EACH ROW EXECUTE PROCEDURE  my_trigger_function();
>
>    Since the trigger is called after each row update the actual row data
> should be available in some way to the trigger.
>    What functionality (SPI ?) do I use to use the column values from
> the current row in the actual trigger?

See "Writing Trigger Functions in C" and "C-Language Functions" in
the documentation.  Here are links to documentation for the latest
version of PostgreSQL:

http://www.postgresql.org/docs/8.0/interactive/trigger-interface.html
http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: George Essig
Date:
Subject: Re: sql question
Next
From: Tom Lane
Date:
Subject: Re: fied separator change from the shell command line