Hello. 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? I have found one speed-inefficient solution: convert NEW to string and then - use EXECURE with customly-build query to extract a value from that constant string. But it is too slow. Is there better solution? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general