Re: Call dynamic PL/PGSQL function - Mailing list pgsql-general

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