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
