This patch updates the docs to reflect the fact that CREATE TABLE AS is
part of the SQL:2003 standard. Patch applied to HEAD.
-Neil
Index: doc/src/sgml/ref/create_table_as.sgml
===================================================================
RCS file: /home/neilc/private-cvsroot/pgsql-server/doc/src/sgml/ref/create_table_as.sgml,v
retrieving revision 1.23
diff -c -r1.23 create_table_as.sgml
*** doc/src/sgml/ref/create_table_as.sgml 24 Aug 2004 00:06:51 -0000 1.23
--- doc/src/sgml/ref/create_table_as.sgml 23 Sep 2004 03:42:07 -0000
***************
*** 166,176 ****
<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.
</para>
</refsect1>
--- 166,199 ----
<title>Compatibility</title>
<para>
! <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>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
