Is EXECUTE slower than a direct assignment call? >-----Original Message----- >From: Vibhor Kumar [mailto:vibhor.kumar@xxxxxxxxxxxxxxxx] >Sent: 1 mars 2011 18:24 >To: Pierre Racine >Cc: pgsql-general@xxxxxxxxxxxxxx >Subject: Re: Dynamic binding in plpgsql function > > >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 >> RETURN x; >> END; >> $$ LANGUAGE 'plpgsql'; >> >> I don't want to do an EXECUTE statement since I have no table to put after the FROM clause. I want >to assign the resulting value directly to a variable like in my example. > > >You don't need any table to assign value of function to Variable, if function returning single value. >You can use EXECUTE 'SELECT '||$1||'(y)' into x; > >Thanks & Regards, >Vibhor Kumar >EnterpriseDB Corporation >The Enterprise PostgreSQL Company >vibhor.kumar@xxxxxxxxxxxxxxxx >Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
