aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>2000-04-07 13:31:18 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>2000-04-07 13:31:18 +0000
commit1b992b468bc5fef62f5a1470f382c70311e9d162 (patch)
tree8c8d69edf2f8b7ad3524380e7c83924fa0299d85
parent30e355fc80996db0334e9d8d28b05dc299500a3e (diff)
downloadpostgresql-1b992b468bc5fef62f5a1470f382c70311e9d162.tar.gz
postgresql-1b992b468bc5fef62f5a1470f382c70311e9d162.zip
Document new SET SEED command.
-rw-r--r--doc/src/sgml/ref/set.sgml40
1 files changed, 39 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index 434fede66b7..f6e7a68cdca 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.35 2000/03/31 17:45:32 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.36 2000/04/07 13:31:18 thomas Exp $
Postgres documentation
-->
@@ -202,6 +202,44 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
</varlistentry>
<varlistentry>
+ <term>Seed</term>
+ <listitem>
+ <para>
+ Sets the internal seed for the random number generator.
+
+ <variablelist>
+ <varlistentry>
+ <term><replaceable class="parameter">value</replaceable></term>
+ <listitem>
+ <para>
+ The value for the seed to be used by the
+ <function>random</function> catalog function. Significant
+ values are floating point numbers between 0 and 1, which
+ are then multiplied by RAND_MAX. This product will
+ silently overflow if a number outside the range is used.
+ </para>
+
+ <para>
+ The seed can also be set by invoking the
+ <function>setseed</function> SQL function:
+
+ <programlisting>
+SELECT setseed(<replaceable>value</replaceable>);
+ </programlisting>
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+
+ <para>
+ This option is only available if MULTIBYTE support was enabled
+ during the configure step of building Postgres.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term>SERVER_ENCODING</term>
<listitem>
<para>