Referencing columns in a record (or dereferencing variables) - Mailing list pgsql-general

From Steve Manes
Subject Referencing columns in a record (or dereferencing variables)
Date
Msg-id 4332E951.3010501@magpie.com
Whole thread Raw
List 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?



pgsql-general by date:

Previous
From: Rafael Martinez
Date:
Subject: Lines of code in PG 8.0 & 8.1?
Next
From: John DeSoi
Date:
Subject: Re: [Re] wrong protocol sequence?