Doug Gorley <doug(dot)gorley(at)gmail(dot)com> 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