Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Basically, my question is why ::regproc alone always addes the catalogue
> qualification in this case?
regproc adds the schema if the name would be ambiguous without it (or
not visible at all). In these cases, the function name is still
ambig
Only regproc adds the unnecessary pg_catalog. qualification, why is that?
Er, I couldn't see the part of your example where that happened?
Basically, my question is why ::regproc alone always addes the catalogue
qualification in this case?
Rows below correspond to:
::regtype
::regtype
::regpro
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Only regproc adds the unnecessary pg_catalog. qualification, why is that?
Er, I couldn't see the part of your example where that happened?
regards, tom lane
---(end of broadcast)
When you do this query:
SET SEARCH_PATH TO pg_catalog;
SELECT castsource::pg_catalog.regtype AS castsource,
casttarget::pg_catalog.regtype AS casttarget,
castfunc::pg_catalog.regprocedure AS castfunc,
castfunc::pg_catalog.regproc AS castfunc2 FROM pg_catalog.pg_cast ORDER
BY 1, 2;
Only regpr