Referencing columns in a record (or dereferencing variables)

From: Steve Manes <smanes(at)magpie(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Referencing columns in a record (or dereferencing variables)
Date: 2005-09-22 17:26:41
Message-ID: 4332E951.3010501@magpie.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In plpgsql, is it possible to indirectly reference a column in a record
object?

For instance, in a trigger function I've got a variable, v_column_name
containing (predictably) a column name in existing in OLD and NEW. I
want to reference that column. This of course doesn't work:

IF OLD.v_column_name != NEW.v_column_name THEN
..

Is this possible in plpgsql? Is there a way to deference v_column_name?

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-09-22 17:51:48 Re: [Re] wrong protocol sequence?
Previous Message Rafael Martinez 2005-09-22 16:53:06 Lines of code in PG 8.0 & 8.1?