Doug Gorley <doug.gorley@xxxxxxxxx> writes: > Perfect, I'm using the following function: > create or replace function fn_sig(p_oid oid) returns text > as $$ > begin > return p_oid::regprocedure; > end; > $$ language plpgsql; > In the following query: > select > pg_namespace.nspname || > '.' || > fn_sig(pg_proc.oid) > from I wouldn't do that if I were you: regprocedure will already schema-qualify the function name if it's needed. The additional qualification you're trying to force will just result in syntax errors. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
