Re: Dynamic Log tigger (plpgsql)

From: "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com>
To: "Noah Heusser" <noah(at)heussers(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic Log tigger (plpgsql)
Date: 2007-06-20 07:04:04
Message-ID: c3a7de1f0706200004y6f43e600reba765590872bec3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Garry Saddington 2007-06-20 07:06:07 Re: Excell
Previous Message Magnus Hagander 2007-06-20 06:59:19 Re: PostgreSQL Installer for Windows x64