Received: from hu.tm.ee (ppp919.tele2.ee [212.107.37.219]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA43608 for ; Sat, 5 Feb 2000 08:26:04 -0500 (EST) (envelope-from hannu@tm.ee) Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP id 317303A0D; Sat, 5 Feb 2000 15:33:14 +0200 (EET) Sender: hannu@hu.tm.ee Message-ID: <389C2699.B81F5921@tm.ee> Date: Sat, 05 Feb 2000 15:33:13 +0200 From: Hannu Krosing Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?= X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13-7mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Chris Cc: "pgsql-hackers@postgreSQL.org" Subject: Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL References: <200002041815.TAA07061@feki.toppoint.de> <389B8250.EB7CF08A@bitmead.com> <389C10F4.63DFB540@tm.ee> <389C1706.9B683710@bitmead.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chris wrote: > > Hannu Krosing wrote: > > > I think the operative word here is "available". I know that SQL specs > > are'nt freely available either, but due to SQL being already widely > > supported one can get the general idea from many freely available sources, > > like the bunch of freely downloadable DB's currently available for linux. > > Most of them have some docs included. > > > > It is still quite a job to reconstruct SQL92 from them ;) > > > > I know now description (except a BNF syntax available from some ODBMS website) > > that I could use to get some idea about OQL. > > Poet at http://www.poet.com have their doco online including OQL. > Thanks, I'll check that. Btw, has anyone compared PostgreSQL's object features with SQL3 (draft) features. For example they seem to use UNDER instead of INHERITS and no parentheses. They also have a special privilege also called UNDER for being able to define a subtype (as they call it). A lot of other features seem to be considered too - no wonder it is 2.3 MB text file. available at: ftp://ftp.digital.com/pub/standards/sql/ or http://gatekeeper.dec.com/pub/standards/sql/ the main file is sql-foundation-aug94.txt ------------------------ Hannu