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