From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bill Studenmund <wrstuden@netbsd.org>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Cc: Fernando Nasser <fnasser@redhat.com>
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: Mon, 28 Jan 2002 10:33:05 +0900
Message-ID: <3C54AA51.64CE68AD@tpf.co.jp> (raw)
References: <Pine.LNX.4.30.0201240003120.686-100000@peter.localdomain>
Is *the path* below the same as "search path* in other
postings about this thread ?
Maybe Peter's posting isn't the one exactly what I have to
ask but there are too many postings for me to follow.
regards,
Hiroshi Inoue
Peter Eisentraut wrote:
>
> Bill Studenmund writes:
>
> > Does SQL'99 say anything about this?
>
> Yes, though, as usual, you have to twist your brain a little to understand
> it. My understanding is that for a function call of the form "foo(a, b)"
> it goes like this:
>
> 1. Find all functions named "foo" in the current database. This is the
> set of "possibly candidate routines".
>
> 2. Drop all routines that you do not have EXECUTE privilege for. This is
> the set of "executable routines".
>
> 3. Drop all routines that do not have compatible parameter lists. This is
> the set of "invocable routines".
>
> 4. Drop all routines whose schema is not in the path. This is the set of
> "candidate routines".
>
> 5. If you have more than one routine left, eliminate some routines
> according to type precedence rules. (We do some form of this, SQL99
> specifies something different.) This yields the set of "candidate subject
> routines".
>
> 6. Choose the routine whose schema is earliest in the path as the "subject
> routine".
>
> Execute the subject routine. Phew!
>
> This doesn't look glaringly wrong to me, so maybe you want to consider it.
> Please note step 2.
>
> --
> Peter Eisentraut peter_e@gmx.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: Inoue@tpf.co.jp, peter_e@gmx.net, tgl@sss.pgh.pa.us, wrstuden@netbsd.org, sszabo@megazone23.bigpanda.com, fnasser@redhat.com
Subject: Re: RFD: schemas and different kinds of Postgres objects
In-Reply-To: <3C54AA51.64CE68AD@tpf.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox