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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
