Re: pass NEW / OLD variable in trigger to table

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(dot)klaver(at)gmail(dot)com