Re: Call dynamic PL/PGSQL function

[Richard Huxton <dev@xxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org