SQL Spec Compliance Questions
От | Josh Berkus |
---|---|
Тема | SQL Spec Compliance Questions |
Дата | |
Msg-id | 200403302050.12415.josh@agliodbs.com обсуждение исходный текст |
Ответы |
Re: [SQL] SQL Spec Compliance Questions
Re: SQL Spec Compliance Questions Re: [SQL] SQL Spec Compliance Questions |
Список | pgsql-advocacy |
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
В списке pgsql-advocacy по дате отправления: