Doug Gorley <doug.gor...@gmail.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
