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