Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >>> That would be great if a C function could find out what schema it had >>> been declared in, but I don't think it can readily do so. >> >> TODO candidate ?
> Seems like it would be a good thing. I take that back: you can find it out if you really want to. You can get your own function OID from the fcinfo->flinfo struct, look that up in pg_proc, and get the pronamespace field. If you want the schema name, and not just its OID, that'll cost you a second cache lookup. Not too many lines of code, though it might be wise to fix things so you need not repeat this each time through the function. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly