Re: How can I get one OLD.* field in a dynamic query inside a trigger function ?

From: Bruno Baguette <bruno(dot)baguette(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I get one OLD.* field in a dynamic query inside a trigger function ?
Date: 2009-10-24 20:24:49
Message-ID: 4AE36291.6010207@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 24/10/09 22:09, Pavel Stehule a écrit :
> you can use plperl or plpython for this task.
>
> Pavel

re-Hello Pavel,

I always used plpgsql because I *thought* it was the most powerfull
procedural language for stored procedures in PostgreSQL.

The fact that PL/pgSQL is most documented than PL/Tcl and PL/Perl (and
PL/Python *seems* to have very poor documentation) has probably made me
wrong.

Which one would you advise me to learn and use, instead of PL/pgSQL ?

Can you explain me why does PL/Perl and PL/Python can does this task
(using OLD in a dynamic query) where PL/pgSQL can't ?

Once again, thanks a lot for your tips ! :-)

Kind regards,

--
Bruno Baguette - bruno(dot)baguette(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-10-24 20:34:56 Re: is postgres a good solution for billion record data.. what about mySQL?
Previous Message Pavel Stehule 2009-10-24 20:09:35 Re: How can I get one OLD.* field in a dynamic query inside a trigger function ?