|
1 | 1 | <!--
|
2 |
| -$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.28 2008/09/08 00:47:40 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.29 2008/10/18 07:49:46 petere Exp $ |
3 | 3 | PostgreSQL documentation
|
4 | 4 | -->
|
5 | 5 |
|
@@ -211,10 +211,13 @@ TRUNCATE othertable CASCADE;
|
211 | 211 | <title>Compatibility</title>
|
212 | 212 |
|
213 | 213 | <para>
|
214 |
| - The draft SQL:2008 standard includes a <command>TRUNCATE</command> command, |
215 |
| - but at this writing it is uncertain whether that will reach standardization |
216 |
| - or be fully compatible with <productname>PostgreSQL</productname>'s |
217 |
| - implementation. |
| 214 | + The SQL:2008 standard includes a <command>TRUNCATE</command> command with the syntax |
| 215 | + <literal>TRUNCATE TABLE <replaceable>tablename</replaceable></literal>. |
| 216 | + The clauses <literal>CONTINUE IDENTITY</literal>/<literal>RESTART IDENTITY</literal> |
| 217 | + also appear in that standard but have slightly different but related meanings. |
| 218 | + Some of the concurrency behavior of this command is left implementation-defined |
| 219 | + by the standard, so the above notes should be considered and compared with |
| 220 | + other implementations if necessary. |
218 | 221 | </para>
|
219 | 222 | </refsect1>
|
220 | 223 | </refentry>
|