|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.23 2004/08/24 00:06:51 neilc Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.24 2004/09/23 03:43:57 neilc Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -166,11 +166,34 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name |
166 | 166 | <title>Compatibility</title> |
167 | 167 |
|
168 | 168 | <para> |
169 | | - This command is modeled after an <productname>Oracle</productname> |
170 | | - feature. There is no command with equivalent functionality in |
171 | | - the SQL standard. However, a combination of <literal>CREATE |
172 | | - TABLE</literal> and <literal>INSERT ... SELECT</literal> can |
173 | | - accomplish the same thing with little more effort. |
| 169 | + <command>CREATE TABLE AS</command> is specified by the SQL2003 |
| 170 | + standard. There are some small differences between the definition |
| 171 | + of the command in SQL2003 and its implementation in |
| 172 | + <productname>PostgreSQL</>: |
| 173 | + |
| 174 | + <itemizedlist spacing="compact"> |
| 175 | + <listitem> |
| 176 | + <para> |
| 177 | + The standard requires parentheses around the subquery clause; in |
| 178 | + <productname>PostgreSQL</productname>, these parentheses are |
| 179 | + optional. |
| 180 | + </para> |
| 181 | + </listitem> |
| 182 | + |
| 183 | + <listitem> |
| 184 | + <para> |
| 185 | + The standard defines an <literal>ON COMMIT</literal> clause; |
| 186 | + this is not currently implemented by <productname>PostgreSQL</>. |
| 187 | + </para> |
| 188 | + </listitem> |
| 189 | + |
| 190 | + <listitem> |
| 191 | + <para> |
| 192 | + The standard defines a <literal>WITH DATA</literal> clause; |
| 193 | + this is not currently implemented by <productname>PostgreSQL</>. |
| 194 | + </para> |
| 195 | + </listitem> |
| 196 | + </itemizedlist> |
174 | 197 | </para> |
175 | 198 | </refsect1> |
176 | 199 |
|
|
