Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread Merlin Moncure
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

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread Merlin Moncure
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 !

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread Pierre Racine
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 >

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread Dmitriy Igrishin
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

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread 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 function with a text parameter >> >> being a ca

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread Dmitriy Igrishin
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

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-02 Thread 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 callback >> function. e.g.: >> >> CREATE OR RE

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-01 Thread Vibhor Kumar
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 >

Re: [GENERAL] Dynamic binding in plpgsql function

2011-03-01 Thread Pavel Stehule
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 $$

[GENERAL] Dynamic binding in plpgsql function

2011-03-01 Thread 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 $$ DECLARE BEGIN RETURN someCal