On Fri, Mar 4, 2011 at 2:03 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 03/04/11 1:57 PM, Matt Warner wrote: > >> Not sure. I believe public and pg_catalog are in the path by default. Most >> of the create function declarations prepend pg_catalog, and I believe I saw >> somewhere that pg_catalog is the default. But I may be misunderstanding >> that... >> > > CREATE FUNCTION nvl(anyelement, anyelement) > RETURNS anyelement > AS '$libdir/orafunc','ora_nvl' > LANGUAGE C IMMUTABLE; > > doesn't specify any schema, so that function is created in the current > schema in the current database > > > Yes, my bad for thinking of this as an Oracle schema as opposed to a different database.
