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/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
