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

From Tom Lane
Subject Re: Question about accessing current row data inside trigger
Date
Msg-id 5639.1110782138@sss.pgh.pa.us
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  (peter Willis <peterw@borstad.com>)
List pgsql-general
peter Willis <peterw@borstad.com> writes:
> I have a trigger function written in C.
> ...
>     Since the trigger is called after each row update the actual row data
> should be available in some way to the trigger.

Sure: tg_trigtuple or tg_newtuple depending on which state you want.
See
http://www.postgresql.org/docs/8.0/static/trigger-interface.html

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: fied separator change from the shell command line
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]