On Wed, Mar 10, 2010 at 7:50 AM, Andrew Dunstan <and...@dunslane.net> wrote: >>> 2010/3/9 strk <s...@keybit.net>: >>>> How can a pl/pgsql trigger change the >>>> values of dynamic fields in NEW record ? >>>> >>>> By "dynamic" I mean that the field name >>>> is a variable in the trigger context. >>>> >>>> I've been told it's easy to do with pl/perl but >>>> I'd like to delive a pl/pgsql solution to have >>>> less dependencies. > > Using an hstore in 9.0 it's not too bad, Try something like: >
Agree 100%. The new hstore going to completely nail a broad class of issues that have historically been awkward in plpgsql functions. (small aside: the other biggie would be able to push a composite type in to an update statement...something like 'update foo set foo = new'). This is really great...some variant of this question is continually asked it seems. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
