Access dynamic NEW.column_name in trigger?

From: Nick <nboutelier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Access dynamic NEW.column_name in trigger?
Date: 2009-10-10 02:23:46
Message-ID: c1d0d97f-0f63-44cf-bf28-8269c075cda9@a37g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-10 02:31:31 Re: Regexp confusion
Previous Message Tom Lane 2009-10-10 02:22:52 Re: Stuck vacuum...