SQL Spec Compliance Questions

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-advocacy(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: SQL Spec Compliance Questions
Date: 2004-03-31 04:50:12
Message-ID: 200403302050.12415.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-sql

Folks,

Just got this "do we support it" questionnaire from a signficant commercial
entity vaguely interested in supporting PostrgreSQL. Since I'm often foggy
on the differences between the SQL99 and SQL92 spec definitions of things, I
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 functions
4) SQL-99 CREATE TRIGGER/DROP TRIGGER
5) SQL-99 BLOB, CLOB Data Types up to 1MB
6) SQL-99 Distinct Types
7) SQL-99 Structured Types
8) SQL-99 Functions, Methods, Procedures
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—begin transaction, commit, abort
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
procedures.
9) ???
10) Also not sure
11) In development, expected within the next two versions. Currently we have
non-SQL-standard recursion by several methods.
12) No
13) Not sure.
14) Yes
15) I think so.

Feedback, please!

--
-Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Lane 2004-03-31 05:18:26 Re: [SQL] SQL Spec Compliance Questions
Previous Message Jacob Hanson 2004-03-31 02:44:28 Perpetuating the myth...annoying

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-31 05:18:26 Re: [SQL] SQL Spec Compliance Questions
Previous Message Ivan Sergio Borgonovo 2004-03-30 22:08:08 plpgsql vs. SQL in stored procedures