SQL conformance related patch
От | Troels Arvin |
---|---|
Тема | SQL conformance related patch |
Дата | |
Msg-id | 1101381875.3068.27.camel@localhost обсуждение исходный текст |
Ответы |
Re: SQL conformance related patch
Re: SQL conformance related patch Re: SQL conformance related patch |
Список | pgsql-patches |
Hello, Simon Riggs, Elein Mustain, and I have worked on adjustments to the information schema and parts of the documentation to reflect upcoming changes in PostgreSQL 8 and changes from SQL:1999 to SQL:2003. Attached is the result of that: A "diff -c" patch for current CVS HEAD. The patch is also available via HTTP[1]. The patch subsumes Simon's patch of November 21 with subject "SQL Conformance introductory section"[2]. Peter's objection to Simon's choice of words has been accommodated. We've had some discussions regarding feature ID F411 (Time zone specification). If we were to be strict, PostgreSQL's support for F411 should be changed to NO, due to a difference in TIMESTAMP literal handling. As it is, the status remains YES, but a comment has been added in the information schema, and the datetime documentation has been expanded a bit. Simon also has ideas for improvement of the conformance documentation page (features.sgml), but that's probably a version 8.1 thing. I think he'd better describe the ideas himself. The list of probably-not-but-just-maybe-supported features in my message as of October 20[3] remains unchanged, but as previously discussed on this list, time is running out. As previously mentioned, I've created a little list of "low hanging fruits" for PostgreSQL's standards-conformance - i.e. features in SQL:2003 which PostgreSQL currently doesn't support but which might actually be relatively easy to implement: http://troels.arvin.dk/db/pgsql/conformance/low-hanging-fruits.txt References: 1: http://troels.arvin.dk/db/pgsql/conformance/pgsql-sql-conformance.patch 2: http://article.gmane.org/gmane.comp.db.postgresql.devel.patches/10318 3: http://article.gmane.org/gmane.comp.db.postgresql.devel.documentation/1278 -- Greetings from Troels Arvin, Copenhagen, Denmark
Вложения
В списке pgsql-patches по дате отправления: