Access dynamic NEW.column_name in trigger?

Started by Nickover 16 years ago2 messagesgeneral
Jump to latest
#1Nick
nboutelier@gmail.com

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;

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Nick (#1)
Re: Access dynamic NEW.column_name in trigger?

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.