Re: Access dynamic NEW.column_name in trigger? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Access dynamic NEW.column_name in trigger?
Date
Msg-id dcc563d10910100040q714f37ebmdf9b4743f1f2ad6e@mail.gmail.com
Whole thread Raw
In response to Access dynamic NEW.column_name in trigger?  (Nick <nboutelier@gmail.com>)
List pgsql-general
On Fri, Oct 9, 2009 at 8:23 PM, Nick <nboutelier@gmail.com> wrote:
> This is a very abbr version of my problem, but what would be the best
> way to do this...
>
> DECLARE
>  column_name_var TEXT;
> BEGIN
>  RETURN NEW.column_name_var;
> END;

plpgsql doesn't really do dynamic column names.  You'll need to
implement it in C, perl, or tcl really.

pgsql-general by date:

Previous
From: Mike Diehl
Date:
Subject: Re: Stuck vacuum...
Next
From: Jasen Betts
Date:
Subject: Re: automated row deletion