Re: Question about accessing current row data inside trigger

From: peter Willis <peterw(at)borstad(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about accessing current row data inside trigger
Date: 2005-03-14 15:59:37
Message-ID: 4235B4E9.5030201@borstad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

This issue is resolved.
I was using the wrong struct.

Peter

Tom Lane wrote:

>peter Willis <peterw(at)borstad(dot)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
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-14 15:59:53 Re: prelimiary performance comparison pgsql vs mysql
Previous Message peter Willis 2005-03-14 15:56:48 Re: Question about accessing current row data inside trigger