|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.21 2001/11/17 22:20:34 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.22 2001/11/28 15:33:48 tgl Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -287,9 +287,20 @@ SELECT * FROM <replaceable>seqname</replaceable>; |
287 | 287 | <title> |
288 | 288 | Notes |
289 | 289 | </title> |
| 290 | + |
290 | 291 | <para> |
291 | 292 | Use <command>DROP SEQUENCE</command> to remove a sequence. |
292 | 293 | </para> |
| 294 | + |
| 295 | + <para> |
| 296 | + Sequences are based on <type>bigint</> arithmetic, so the range cannot |
| 297 | + exceed the range of an eight-byte integer |
| 298 | + (-9223372036854775808 to 9223372036854775807). On some older platforms, |
| 299 | + there may be no compiler support for eight-byte integers, in which case |
| 300 | + sequences use regular <type>integer</> arithmetic (range |
| 301 | + -2147483648 to +2147483647). |
| 302 | + </para> |
| 303 | + |
293 | 304 | <para> |
294 | 305 | When <replaceable class="parameter">cache</replaceable> is greater than |
295 | 306 | one, each backend uses its own cache to store preallocated numbers. |
|