Received: from eta.ece.rice.edu (ece.rice.edu [128.42.4.34]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA25075 for ; Thu, 25 Feb 1999 14:05:33 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: from rice.edu (wallace.ece.rice.edu [128.42.12.154]) by eta.ece.rice.edu (8.9.0/8.9.0) with ESMTP id NAA11925 for ; Thu, 25 Feb 1999 13:01:22 -0600 (CST) Sender: reedstrm@ece.rice.edu Message-ID: <36D59EFA.26DEE249@rice.edu> Date: Thu, 25 Feb 1999 13:05:30 -0600 From: "Ross J. Reedstrom" Organization: NSBRI X-Mailer: Mozilla 4.06 [en] (X11; U; Linux 2.0.34 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around?? References: <4.1.19990224201140.009a9820@mail.venux.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Matthew Hagerty wrote: > > All I could find on the web site was that PostgreSQL supports a subset of > SQL92 and SQL3. Is there someplace that tells what that subset is? This is a very important question for PostgreSQL as a whole. Does anyone know what is missing to claim SQL92 compliance? I can get my higher-ups to agree that we should adopt software based on it's conformance to existing standards, to avoid the proprietary lock-in problem. This is usually my strategy for getting Open Source software in ;-) since it conforms so much better (usually) When I discovered PostgrSQL is a little short in that department, I've had to mumble and hand-wave a little. Some of us postgreSQL users could help the core developers a lot on this. I'd love to see an extension of the DB comparison table on the web page, with SQL standard features listed. I realize the actual text of the SQL92 standard must be purchased, but is there a 'bullet list' version anywhere? I can't seem to find one via altavista. Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005