PostgreSQL Discussion - Referencing columns in a record (or dereferencing variables)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Referencing columns in a record (or dereferencing variables)

Steve Manes

2005-09-22, 1:23 pm

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?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links