Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit90edb26

Browse files
author
Thomas G. Lockhart
committed
Implement SQL99 CREATE CAST and DROP CAST statements.
 Also implement alternative forms to expose the PostgreSQL CREATE FUNCTION features.Implement syntax for READ ONLY and READ WRITE clauses in SET TRANSACTION. READ WRITE is already implemented (of course).Implement syntax for "LIKE table" clause in CREATE TABLE. Should be fairly easy to complete since it resembles SELECT INTO.Implement MATCH SIMPLE clause for foreign key definitions. This is explicit SQL99 syntax for the default behavior, so we now support it :)Start implementation of shorthand for national character literals in scanner. For now, just swallow the leading "N", but sometime soon let's figure out how to pass leading type info from the scanner to the parser. We should use the same technique for binary and hex bit string literals, though it might be unusual to have two apparently independent literal types fold into the same storage type.
1 parentcc8839a commit90edb26

File tree

4 files changed

+258
-186
lines changed

4 files changed

+258
-186
lines changed

‎doc/src/sgml/features.sgml

Lines changed: 29 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -1,29 +1,29 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 thomas Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.3 2002/06/22 02:04:55 thomas Exp $
33
-->
44

55
<appendix id="features">
66
<title>SQL99 Feature List</title>
77

8-
<sect1 id="features-sql99">
9-
<title>Supported Features</title>
8+
<para>
9+
<acronym>SQL92</acronym> defined three feature sets for
10+
compliance: basic, intermediate, and advanced. Most database
11+
products claiming <acronym>SQL</acronym> standards compliance were
12+
compliant at only the basic level, since the entire set of
13+
intermediate and advanced features was either too voluminous or in
14+
conflict with legacy behaviors.
15+
</para>
1016

11-
<para>
12-
<acronym>SQL92</acronym> defined three feature sets for
13-
compliance: basic, intermediate, and advanced. Most database
14-
products claiming <acronym>SQL</acronym> standards compliance were
15-
compliant at only the basic level, since the entire set of
16-
intermediate and advanced features was either too voluminous or in
17-
conflict with legacy behaviors.
18-
</para>
17+
<para>
18+
<acronym>SQL99</acronym> defines a large set of individual
19+
features rather than the ineffectively broad three levels found in
20+
<acronym>SQL92</acronym>. We provide a list of supported features,
21+
followed by a list of the features defined in SQL99 which are not
22+
yet supported in PostgreSQL.
23+
</para>
1924

20-
<para>
21-
<acronym>SQL99</acronym> defines a large set of individual
22-
features rather than the ineffectively broad three levels found in
23-
<acronym>SQL92</acronym>. We provide a list of supported features,
24-
followed by a list of the features defined in SQL99 which are not
25-
yet supported in PostgreSQL.
26-
</para>
25+
<sect1 id="features-sql99">
26+
<title>Supported Features</title>
2727

2828
<para>
2929
<informaltable>
@@ -1132,6 +1132,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho
11321132
<entry>Array as result type of functions</entry>
11331133
<entry></entry>
11341134
</row>
1135+
<row>
1136+
<entry>S211</entry>
1137+
<entry>User-defined cast functions</entry>
1138+
<entry>CREATE CAST(type AS type)</entry>
1139+
</row>
11351140
<row>
11361141
<entry>T031</entry>
11371142
<entry>BOOLEAN data type</entry>
@@ -1147,11 +1152,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho
11471152
<entry>DISTINCT predicate</entry>
11481153
<entry></entry>
11491154
</row>
1150-
<row>
1151-
<entry>T171</entry>
1152-
<entry>LIKE clause in table definition</entry>
1153-
<entry></entry>
1154-
</row>
11551155
<row>
11561156
<entry>T191</entry>
11571157
<entry>Referential action RESTRICT</entry>
@@ -1318,7 +1318,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho
13181318
<entry>E152-02</entry>
13191319
<entry>SET TRANSACTION statement: READ ONLY and READ WRITE
13201320
clauses</entry>
1321-
<entry></entry>
1321+
<entry>Syntax accepted; READ ONLY not supported</entry>
13221322
</row>
13231323
<row>
13241324
<entry>E171</entry>
@@ -1621,11 +1621,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho
16211621
<entry>Subtype treatment</entry>
16221622
<entry>TREAT(expr AS type)</entry>
16231623
</row>
1624-
<row>
1625-
<entry>S211</entry>
1626-
<entry>User-defined cast functions</entry>
1627-
<entry>CREATE CAST(type AS type) WITH</entry>
1628-
</row>
16291624
<row>
16301625
<entry>S231</entry>
16311626
<entry>Structured type locators</entry>
@@ -1712,6 +1707,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.2 2002/06/19 06:11:36 tho
17121707
<entry>Recursive query</entry>
17131708
<entry></entry>
17141709
</row>
1710+
<row>
1711+
<entry>T171</entry>
1712+
<entry>LIKE clause in table definition</entry>
1713+
<entry>CREATE TABLE T1 (LIKE T2)</entry>
1714+
</row>
17151715
<row>
17161716
<entry>T211-05</entry>
17171717
<entry>Ability to specify a search condition that must be true

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp