diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/features.sgml | 58 |
1 files changed, 29 insertions, 29 deletions
diff --git a/doc/src/sgml/features.sgml b/doc/src/sgml/features.sgml index b023225a158..06b4f4e0acd 100644 --- a/doc/src/sgml/features.sgml +++ b/doc/src/sgml/features.sgml @@ -1,29 +1,29 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.3 2002/06/22 02:04:55 thomas Exp $ --> <appendix id="features"> <title>SQL99 Feature List</title> - <sect1 id="features-sql99"> - <title>Supported Features</title> + <para> + <acronym>SQL92</acronym> defined three feature sets for + compliance: basic, intermediate, and advanced. Most database + products claiming <acronym>SQL</acronym> standards compliance were + compliant at only the basic level, since the entire set of + intermediate and advanced features was either too voluminous or in + conflict with legacy behaviors. + </para> - <para> - <acronym>SQL92</acronym> defined three feature sets for - compliance: basic, intermediate, and advanced. Most database - products claiming <acronym>SQL</acronym> standards compliance were - compliant at only the basic level, since the entire set of - intermediate and advanced features was either too voluminous or in - conflict with legacy behaviors. - </para> + <para> + <acronym>SQL99</acronym> defines a large set of individual + features rather than the ineffectively broad three levels found in + <acronym>SQL92</acronym>. We provide a list of supported features, + followed by a list of the features defined in SQL99 which are not + yet supported in PostgreSQL. + </para> - <para> - <acronym>SQL99</acronym> defines a large set of individual - features rather than the ineffectively broad three levels found in - <acronym>SQL92</acronym>. We provide a list of supported features, - followed by a list of the features defined in SQL99 which are not - yet supported in PostgreSQL. - </para> + <sect1 id="features-sql99"> + <title>Supported Features</title> <para> <informaltable> @@ -1133,6 +1133,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho <entry></entry> </row> <row> + <entry>S211</entry> + <entry>User-defined cast functions</entry> + <entry>CREATE CAST(type AS type)</entry> + </row> + <row> <entry>T031</entry> <entry>BOOLEAN data type</entry> <entry></entry> @@ -1148,11 +1153,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho <entry></entry> </row> <row> - <entry>T171</entry> - <entry>LIKE clause in table definition</entry> - <entry></entry> - </row> - <row> <entry>T191</entry> <entry>Referential action RESTRICT</entry> <entry></entry> @@ -1318,7 +1318,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho <entry>E152-02</entry> <entry>SET TRANSACTION statement: READ ONLY and READ WRITE clauses</entry> - <entry></entry> + <entry>Syntax accepted; READ ONLY not supported</entry> </row> <row> <entry>E171</entry> @@ -1622,11 +1622,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho <entry>TREAT(expr AS type)</entry> </row> <row> - <entry>S211</entry> - <entry>User-defined cast functions</entry> - <entry>CREATE CAST(type AS type) WITH</entry> - </row> - <row> <entry>S231</entry> <entry>Structured type locators</entry> <entry></entry> @@ -1713,6 +1708,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho <entry></entry> </row> <row> + <entry>T171</entry> + <entry>LIKE clause in table definition</entry> + <entry>CREATE TABLE T1 (LIKE T2)</entry> + </row> + <row> <entry>T211-05</entry> <entry>Ability to specify a search condition that must be true before the trigger is invoked</entry> |