Re: [GENERAL] PLPGSQL Generic query in trigger doubt

2011-08-10 Thread Ioana Danes
Hi Mauro, If you try to determine what fields were changed you can check this post: http://jaime2ndquadrant.blogspot.com/ It might work for you. Ioana --- On Wed, 8/10/11, Mauro wrote: Hi, good morning list I'm writing a generic trigger in plpgsql to provide a system log to my system, but I'

Re: [GENERAL] PLPGSQL Generic query in trigger doubt

2011-08-10 Thread Merlin Moncure
On Wed, Aug 10, 2011 at 8:38 AM, Mauro wrote: > Hi, good morning list > I'm writing a generic trigger in plpgsql to provide a system log to my > system, but I'm stopped with the folow problem: > Example: > TABLE STRUCT: > table1 >    fldA    VARCHAR >    fldB    VARCHAR >    fldC    VARCHAR > FUNC

[GENERAL] PLPGSQL Generic query in trigger doubt

2011-08-10 Thread Mauro
Hi, good morning list I'm writing a generic trigger in plpgsql to provide a system log to my system, but I'm stopped with the folow problem: Example: TABLE STRUCT: table1    fldA    VARCHAR    fldB    VARCHAR    fldC    VARCHAR FUNCTION: DECLARE    myrecord RECORD; -- record that will be