Thread: Call dynamic PL/PGSQL function

Hi,
what's the best way in pl/pgsql to call a function with a dynamic name
from inside another pl/plsql function?

like..

SELECT INTO
   function_name
   name
FROM
   functions
WHERE
   bar;

EXECUTE function_name..??


Thanks in advance

Hannes Dorbath wrote:
> Hi,
> what's the best way in pl/pgsql to call a function with a dynamic name
> from inside another pl/plsql function?
>
> like..
>
> SELECT INTO
>   function_name
>   name
> FROM
>   functions
> WHERE
>   bar;
>
> EXECUTE function_name..??

Almost

my_query = ''SELECT '' || function_name ''()'';
EXECUTE my_query;

Also check out the quote_ functions in case you have mixed-case function
names etc.
--
   Richard Huxton
   Archonet Ltd