Re: [SQL] Accessing field of OLD in trigger

2007-10-12 Thread Erik Jones
On Oct 12, 2007, at 8:18 AM, Josh Trutwin wrote: On Fri, 12 Oct 2007 12:00:55 +0200 (CEST) Daniel Drotos <[EMAIL PROTECTED]> wrote: Hi, I'm working on a row level plpgsql trigger running after delete, using a 8.0.3 server. It gets a parameter which is a field name of the OLD record. How can

Re: [SQL] Accessing field of OLD in trigger

2007-10-12 Thread Josh Trutwin
On Fri, 12 Oct 2007 12:00:55 +0200 (CEST) Daniel Drotos <[EMAIL PROTECTED]> wrote: > Hi, > > > I'm working on a row level plpgsql trigger running after delete, > using a 8.0.3 server. It gets a parameter which is a field name of > the OLD record. How can that field be accessed? > > I'd like to

[SQL] Accessing field of OLD in trigger

2007-10-12 Thread Daniel Drotos
Hi, I'm working on a row level plpgsql trigger running after delete, using a 8.0.3 server. It gets a parameter which is a field name of the OLD record. How can that field be accessed? I'd like to do something like: for recvar in 'select OLD.'||quote_ident(TG_ARGV[0])... Daniel Ps: sorry a

[SQL] Accessing field of OLD in trigger

2007-10-11 Thread Daniel Drotos
Hi, I'm working on a row level plpgsql trigger running after delete, using a 8.0.3 server. It gets a parameter which is a field name of the OLD record. How can that field be accessed? I'd like to do something like: for recvar in 'select OLD.'||quote_ident(TG_ARGV[0])... Daniel