Thread: pass NEW / OLD variable in trigger to table
Hello, I'm using some trigger functions on a view. Can I pass the NEW / OLD variable to the table of the view? An excerpt of my view shows: IF TG_OP = 'INSERT' then insert into mytable (name, data, commentdata, history) values (NEW.name, NEW.data, NEW.commentdata, NEW.history); ernd if; Can I do anything like "insert into mytable values (NEW)" ? Can I do this with update and delete also? I would like to pass the variable with the "action" to the table, so I need not to reference the fields Thanks Phil
On 06/09/2012 05:49 AM, Philipp Kraus wrote: > Hello, > > I'm using some trigger functions on a view. Can I pass the NEW / OLD variable to the table of the view? > An excerpt of my view shows: > > IF TG_OP = 'INSERT' then > insert into mytable (name, data, commentdata, history) values (NEW.name, NEW.data, NEW.commentdata, NEW.history); > ernd if; > > Can I do anything like "insert into mytable values (NEW)" ? Can I do this with update and delete also? > I would like to pass the variable with the "action" to the table, so I need not to reference the fields http://www.postgresql.org/docs/9.1/interactive/plpgsql-trigger.html See Example 39-4. A PL/pgSQL Trigger Procedure For Auditing > > Thanks > > Phil > > -- Adrian Klaver adrian.klaver@gmail.com