|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.35 2000/03/31 17:45:32 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.36 2000/04/07 13:31:18 thomas Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -201,6 +201,44 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } |
201 | 201 | </listitem> |
202 | 202 | </varlistentry> |
203 | 203 |
|
| 204 | + <varlistentry> |
| 205 | + <term>Seed</term> |
| 206 | + <listitem> |
| 207 | + <para> |
| 208 | +Sets the internal seed for the random number generator. |
| 209 | + |
| 210 | +<variablelist> |
| 211 | + <varlistentry> |
| 212 | + <term><replaceable class="parameter">value</replaceable></term> |
| 213 | + <listitem> |
| 214 | + <para> |
| 215 | + The value for the seed to be used by the |
| 216 | + <function>random</function> catalog function. Significant |
| 217 | + values are floating point numbers between 0 and 1, which |
| 218 | + are then multiplied by RAND_MAX. This product will |
| 219 | + silently overflow if a number outside the range is used. |
| 220 | + </para> |
| 221 | + |
| 222 | + <para> |
| 223 | + The seed can also be set by invoking the |
| 224 | + <function>setseed</function> SQL function: |
| 225 | + |
| 226 | + <programlisting> |
| 227 | +SELECT setseed(<replaceable>value</replaceable>); |
| 228 | + </programlisting> |
| 229 | + </para> |
| 230 | + </listitem> |
| 231 | + </varlistentry> |
| 232 | +</variablelist> |
| 233 | + </para> |
| 234 | + |
| 235 | + <para> |
| 236 | +This option is only available if MULTIBYTE support was enabled |
| 237 | +during the configure step of building Postgres. |
| 238 | + </para> |
| 239 | + </listitem> |
| 240 | + </varlistentry> |
| 241 | + |
204 | 242 | <varlistentry> |
205 | 243 | <term>SERVER_ENCODING</term> |
206 | 244 | <listitem> |
|
