Re: [GENERAL] Question about accessing current row data inside trigger

2005-03-20 Thread peter Willis
Hello, I resolved this issue already. The trigger now works fine. I was looking at the wrong structure. Thanks, Peter Michael Fuhr wrote: 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

Re: [GENERAL] Question about accessing current row data inside trigger

2005-03-20 Thread peter Willis
Hello, This issue is resolved. I was using the wrong struct. Peter Tom Lane wrote: peter Willis <[EMAIL PROTECTED]> 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. Su

Re: [GENERAL] Question about accessing current row data inside trigger

2005-03-13 Thread Tom Lane
peter Willis <[EMAIL PROTECTED]> 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

Re: [GENERAL] Question about accessing current row data inside trigger

2005-03-13 Thread Michael Fuhr
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

[GENERAL] Question about accessing current row data inside trigger

2005-03-13 Thread peter Willis
Hello, 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 wa