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 g0U0Kil91336 for ; Tue, 29 Jan 2002 19:20:45 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: (qmail 18978 invoked from network); 30 Jan 2002 00:20:46 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 30 Jan 2002 00:20:46 -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 JAA08622; Wed, 30 Jan 2002 09:20:44 +0900 (JST) Message-ID: <3C573C5E.F01B48C2@tpf.co.jp> Date: Wed, 30 Jan 2002 09:20:46 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Bill Studenmund , Peter Eisentraut , Tom Lane CC: PostgreSQL Development 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/1309 X-Sequence-Number: 18273 Bill Studenmund wrote: > > On Tue, 29 Jan 2002, Hiroshi Inoue wrote: > > > What I can find in SQL99 is SQL-path. > > Does *the path*(i.e search path) mean SQL-path ? > > They don't seem the same to me. > > While we may have not been using the terminology of the spec, I think we > have been talking about schema paths from SQL99. > > One difference between our discussions and SQL99 I've noticed is that > we've spoken of having the path find functions (and operators and > aggregates), types, _and_tables_. My understanding is the same. Tom, Peter is it right ? > SQL99 doesn't have tables in there > AFAICT, but I think it makes sense. It seems to make sense but they are different and our *path* is never an extension of SQL-path. Where are the difference or the relevance referred to in this thread ? regards, Hiroshi Inoue