Re: [GENERAL] Indirect access to NEW or OLD records

"Dmitry Koterov" <dmitry@koterov.ru> writes:
> I have a variable with a field name and want to extract this field
> value from NEW record:

> DECLARE
> field VARCHAR = 'some_field';
> BEGIN
> ...
> value := NEW.{field}; -- ???
> END;

> Is it possible in pl/pgsql?

No. Quite aside from the lack of syntax for that, plpgsql would be
unhappy if the data type wasn't the same on successive executions.

Use one of the less strongly typed PLs instead. I believe this is
pretty easy in plperl or pltcl. (Maybe plpython too, but I don't know
that language.)

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general