Re: Schema name of function

On Mon, Feb 14, 2005 at 11:11:53AM -0500, Tom Lane wrote:
> 
> In C, it'd be a lot easier (and faster) to do a couple of SearchSysCache
> calls than to use SPI to get those rows.

The following appears to work -- does it look right, aside from the
missing error checking?
 tuple = SearchSysCache(PROCOID,                        ObjectIdGetDatum(fcinfo->flinfo->fn_oid),
0, 0, 0); nsoid = SysCacheGetAttr(PROCOID, tuple,                         Anum_pg_proc_pronamespace, &isnull);
schemaname= get_namespace_name(nsoid); ReleaseSysCache(tuple);
 

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/