On Wed, Mar 2, 2011 at 9:06 AM, Pierre Racine
wrote:
> Is EXECUTE slower than a direct assignment call?
It is going to be slower, but how much slower and if it justifies the
mechanism is going to be a matter of your requirements, definition of
'slow', and willingness to experiment.
merlin
--
S
On Wed, Mar 2, 2011 at 8:54 AM, Dmitriy Igrishin wrote:
> 2011/3/2 Merlin Moncure
>> Lane...http://postgresql.1045698.n5.nabble.com/improvise-callbacks-in-plpgsql-td2052928.html
>> (for whom nary a day goes by that I am not thankful for his tireless
>> efforts).
>
> Ahh, thanks to Tom Lane then !
Is EXECUTE slower than a direct assignment call?
>-Original Message-
>From: Vibhor Kumar [mailto:vibhor.ku...@enterprisedb.com]
>Sent: 1 mars 2011 18:24
>To: Pierre Racine
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Dynamic binding in plpgsql function
>
2011/3/2 Merlin Moncure
> On Wed, Mar 2, 2011 at 8:34 AM, Dmitriy Igrishin
> wrote:
> > 2011/3/2 Merlin Moncure
> >> On Tue, Mar 1, 2011 at 5:17 PM, Pavel Stehule
> >> wrote:
> >> > Hello
> >> >
> >> > 2011/3/2 Pierre Racine :
> >> >> Hi,
> >> >>
> >> >> I would like to write a generic plpgsql
On Wed, Mar 2, 2011 at 8:34 AM, Dmitriy Igrishin wrote:
> 2011/3/2 Merlin Moncure
>> On Tue, Mar 1, 2011 at 5:17 PM, Pavel Stehule
>> wrote:
>> > Hello
>> >
>> > 2011/3/2 Pierre Racine :
>> >> Hi,
>> >>
>> >> I would like to write a generic plpgsql function with a text parameter
>> >> being a ca
2011/3/2 Merlin Moncure
> On Tue, Mar 1, 2011 at 5:17 PM, Pavel Stehule
> wrote:
> > Hello
> >
> > 2011/3/2 Pierre Racine :
> >> Hi,
> >>
> >> I would like to write a generic plpgsql function with a text parameter
> being a callback function name so that my general function can call this
> callb
On Tue, Mar 1, 2011 at 5:17 PM, Pavel Stehule wrote:
> Hello
>
> 2011/3/2 Pierre Racine :
>> Hi,
>>
>> I would like to write a generic plpgsql function with a text parameter being
>> a callback function name so that my general function can call this callback
>> function. e.g.:
>>
>> CREATE OR RE
On Mar 2, 2011, at 4:31 AM, Pierre Racine wrote:
> CREATE OR REPLACE FUNCTION ST_MyGeneralFunction(callback text)
>RETURNS SETOF geomval AS $$
>DECLARE
>x integer;
>y integer;
>BEGIN
>y := somecalculation;
>x := 'callback'(y); --This is what I need
>
Hello
2011/3/2 Pierre Racine :
> Hi,
>
> I would like to write a generic plpgsql function with a text parameter being
> a callback function name so that my general function can call this callback
> function. e.g.:
>
> CREATE OR REPLACE FUNCTION ST_MyCallbackFunction(y int)
> RETURNS int AS $$
