[SQL] SQL Spec Compliance Questions
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]
Re: [SQL] SQL Spec Compliance Questions
Josh Berkus <[EMAIL PROTECTED]> writes: > Just got this "do we support it" questionnaire from a signficant commercial > entity vaguely interested in supporting PostrgreSQL. This looks more like an underling with a checklist than a serious inquiry. Can you get them to specify particular capabilities that they need? In sufficient detail that we could actually answer? regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] SQL Spec Compliance Questions
Tom, > This looks more like an underling with a checklist than a serious > inquiry. Can you get them to specify particular capabilities that they > need? In sufficient detail that we could actually answer? I'll ask, but I'm not sure that I can. The particular company is very bureaucratic, and I doubt the person who asked me has any control over the questionnaire. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 651-9224 and non-profit organizations. San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[SQL] plpgsql vs. SQL in stored procedures
Is there a way to declare variables and use IF in plain SQL, not in plpgsql inside stored procedures? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
