| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, strk(at)keybit(dot)net |
| Subject: | Re: Dyamic updates of NEW with pl/pgsql |
| Date: | 2010-03-10 11:38:36 |
| Message-ID: | 20100310113836.GA2700@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Mar 09, 2010 at 06:59:31PM +0100, Pavel Stehule wrote:
> 2010/3/9 strk <strk(at)keybit(dot)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.
>
> It isn't possible yet
well, it's possible. it's just not nice.
http://www.depesz.com/index.php/2010/03/10/dynamic-updates-of-fields-in-new-in-plpgsql/
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2010-03-10 12:50:16 | Re: Dyamic updates of NEW with pl/pgsql |
| Previous Message | Greg Stark | 2010-03-10 11:38:12 | Re: Re: Hot Standby query cancellation and Streaming Replication integration |