Re: Dyamic updates of NEW with pl/pgsql

On Fri, Mar 12, 2010 at 07:35:41PM +0100, Pavel Stehule wrote:
> 2010/3/12 David Fetter <david@fetter.org>:
> >
> > This is, by the way, an excellent argument for including hstore in
> > core in 9.1. :)
> 
> I like it - but it looking little bit strange - I thinking we need
> only one function (maybe with some special support from pl executor)
> 
> begin
>   update_field(NEW, 'field', value);
>   ....

This doesn't seem like a terribly useful addition, it being specific
to PL/pgsql.  Then there's the quoting issue, which the above doesn't
quite address.  Putting hstore in would let all the other PLs use it,
to the extent that they need such a thing. :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate