diff options
| author | Neil Conway <neilc@samurai.com> | 2004-09-23 03:43:57 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2004-09-23 03:43:57 +0000 |
| commit | 505d9be3e66362ab52cadc5f9236a56cc4725ed0 (patch) | |
| tree | 908324341b68bd69620b1d922e6992c3db6d41e0 | |
| parent | 6a84723d7d6162e7e745ce8f16b9b5d80bea1af7 (diff) | |
| download | postgresql-505d9be3e66362ab52cadc5f9236a56cc4725ed0.tar.gz postgresql-505d9be3e66362ab52cadc5f9236a56cc4725ed0.zip | |
Update CREATE TABLE AS docs to reflect the fact that CREATE TABLE AS was
added to the SQL:2003 standard.
| -rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 35 |
1 files changed, 29 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 6c7566781b4..2e0115e87db 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.23 2004/08/24 00:06:51 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.24 2004/09/23 03:43:57 neilc Exp $ PostgreSQL documentation --> @@ -166,11 +166,34 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name <title>Compatibility</title> <para> - This command is modeled after an <productname>Oracle</productname> - feature. There is no command with equivalent functionality in - the SQL standard. However, a combination of <literal>CREATE - TABLE</literal> and <literal>INSERT ... SELECT</literal> can - accomplish the same thing with little more effort. + <command>CREATE TABLE AS</command> is specified by the SQL2003 + standard. There are some small differences between the definition + of the command in SQL2003 and its implementation in + <productname>PostgreSQL</>: + + <itemizedlist spacing="compact"> + <listitem> + <para> + The standard requires parentheses around the subquery clause; in + <productname>PostgreSQL</productname>, these parentheses are + optional. + </para> + </listitem> + + <listitem> + <para> + The standard defines an <literal>ON COMMIT</literal> clause; + this is not currently implemented by <productname>PostgreSQL</>. + </para> + </listitem> + + <listitem> + <para> + The standard defines a <literal>WITH DATA</literal> clause; + this is not currently implemented by <productname>PostgreSQL</>. + </para> + </listitem> + </itemizedlist> </para> </refsect1> |