Re: Dynamic Log tigger (plpgsql) - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Dynamic Log tigger (plpgsql)
Date
Msg-id c3a7de1f0706200004y6f43e600reba765590872bec3@mail.gmail.com
Whole thread Raw
In response to Dynamic Log tigger (plpgsql)  (Noah Heusser <noah@heussers.ch>)
Responses Re: Dynamic Log tigger (plpgsql)  (Noah Heusser <pgsql-general@heussers.ch>)
List pgsql-general
> My Question:
> How can I do "OLD.columnName != NEW.columnName" if I don't know what the
> columnNames are at Compile Time?
> I have the columnName in a variable.
>

I suggest you use plpython. In this case you'll be able to do it.

TD['old'][colNameVar] != TD['new'][colNameVar]

--
Regards,
Sergey Konoplev

pgsql-general by date:

Previous
From: Garry Saddington
Date:
Subject: Re: Excell
Next
From: "EBIHARA, Yuichiro"
Date:
Subject: Re: PostgreSQL Installer for Windows x64