X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 349B8D1D52A; Wed, 31 Mar 2004 04:50:48 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 38984-02; Wed, 31 Mar 2004 00:50:47 -0400 (AST)
Received: from davinci.ethosmedia.com (server228.ethosmedia.com
	[209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP
	id E4DD4D1D391; Wed, 31 Mar 2004 00:50:45 -0400 (AST)
Received: from [63.195.55.98] (HELO 192.168.1.29)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP id 4737137; Tue, 30 Mar 2004 20:52:03 -0800
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-advocacy@postgresql.org, pgsql-sql@postgresql.org
Subject: SQL Spec Compliance Questions
Date: Tue, 30 Mar 2004 20:50:12 -0800
User-Agent: KMail/1.5.4
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200403302050.12415.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/142
X-Sequence-Number: 3961

Folks,

Just got this "do we support it" questionnaire from a signficant commercial=
=20
entity vaguely interested in supporting PostrgreSQL.    Since I'm often fog=
gy=20
on the differences between the SQL99 and SQL92 spec definitions of things, =
I=20
thought I'd post it for feedback here:

1) SQL-92 SELECT, INSERT, UPDATE, DELETE
2) SQL-92 CREATE/DROP SCHEMA/TABLE
3) SQL-92 INFORMATION_SCHEMA or SQL/CLI or ODBC driver with metadata functi=
ons
4) SQL-99 CREATE TRIGGER/DROP TRIGGER
5) SQL-99 BLOB, CLOB Data Types up to 1MB
6) SQL-99 Distinct Types=20
7) SQL-99 Structured Types=20
8) SQL-99 Functions, Methods, Procedures=20
9) SQL-99 Collection Types
10) SQL-99 Typed tables and views
11) SQL-99 Recursion
12) SQL/CLI or ODBC driver supports asynchronous statement execution
13) SQL/CLI or ODBC driver Supports all required SQL features
14) Transaction management functions=E2=80=94begin transaction, commit, abo=
rt
15) Wire protocol documentation and software

My answers:

1) Yes
2) yes
3) Yes -- INFORMATION_SCHEMA
4) Yes, unless SQL99 has some wierd twist on triggers.
6), 7) Not sure what these are.
8) Functions, yes, and in PostgreSQL functions are capable of acting as=20
procedures.=20=20=20
9) ???
10) Also not sure
11) In development, expected within the next two versions.  Currently we ha=
ve=20
non-SQL-standard recursion by several methods.
12) No
13) Not sure.
14) Yes
15) I think so.

Feedback, please!

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco