Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0S1X4l84668 for ; Sun, 27 Jan 2002 20:33:04 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: (qmail 4010 invoked from network); 28 Jan 2002 01:33:07 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 28 Jan 2002 01:33:07 -0000 Received: from tpf.co.jp (3dgateway1 [126.0.1.60]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id KAA05318; Mon, 28 Jan 2002 10:33:04 +0900 (JST) Message-ID: <3C54AA51.64CE68AD@tpf.co.jp> Date: Mon, 28 Jan 2002 10:33:05 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Peter Eisentraut , Tom Lane CC: Bill Studenmund , Stephan Szabo , PostgreSQL Development , Fernando Nasser Subject: Re: RFD: schemas and different kinds of Postgres objects References: Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/1271 X-Sequence-Number: 18236 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