summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas G. Lockhart1998-10-14 16:31:28 +0000
committerThomas G. Lockhart1998-10-14 16:31:28 +0000
commit6129de0b76005d22e87704bf174ee2122f42a4ee (patch)
tree39414f77f18329df87c3b153a3d66e9ef60ca6e0
parent963ed0e72ae532bf6699d32dbae3c21ec205754b (diff)
Remove duplicate entry for R_PLAN (thanks Bruce).
Add entry for undocumented (?) KSQO.
-rw-r--r--doc/src/sgml/ref/set.sgml46
1 files changed, 25 insertions, 21 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index 87742007efc..8b840294716 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -20,7 +20,6 @@ SET
<REPLACEABLE CLASS="PARAMETER">
</REPLACEABLE>
SET <REPLACEABLE CLASS="PARAMETER">variable</REPLACEABLE> { TO | = } { '<REPLACEABLE CLASS="PARAMETER">value</REPLACEABLE>' | DEFAULT }
-
SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL };
</SYNOPSIS>
@@ -52,7 +51,7 @@ New value of parameter.
</variablelist>
<para>
- The possible variables and allowed values are:
+The possible variables and allowed values are:
<VARIABLELIST>
<VARLISTENTRY>
@@ -197,16 +196,18 @@ set time zone to your local timezone
</variablelist>
<para>
- If an invalid time zone is specified, the time zone
- becomes GMT (on most systems anyway).
+If an invalid time zone is specified, the time zone
+becomes GMT (on most systems anyway).
+
<para>
- A frontend which uses libpq may be initialized by setting the PGTZ
- environment variable.
+A frontend which uses libpq may be initialized by setting the PGTZ
+environment variable.
+
<para>
- The second syntax shown above, allows one to set the timezone
- with a syntax similar to SQL92 <command>SET TIME ZONE</command>.
- The LOCAL keyword is just an alternate form
- of DEFAULT for SQL92 compatibility.
+The second syntax shown above, allows one to set the timezone
+with a syntax similar to SQL92 <command>SET TIME ZONE</command>.
+The LOCAL keyword is just an alternate form
+of DEFAULT for SQL92 compatibility.
</varlistentry>
</variablelist>
@@ -315,7 +316,7 @@ DEFAULT
</term>
<listitem>
<para>
-Equivalent to specifying <command>SET GEQO=On</command>
+Equivalent to specifying <command>SET GEQO='on'</command>
</varlistentry>
</variablelist>
@@ -361,7 +362,7 @@ DEFAULT
</term>
<listitem>
<para>
-Equivalent to specifying <command>SET R_PLANS=Off</command>.
+Equivalent to specifying <command>SET R_PLANS='off'</command>.
</variablelist>
<para>
@@ -375,11 +376,13 @@ Equivalent to specifying <command>SET R_PLANS=Off</command>.
<varlistentry>
<term>
-R_PLANS
+KSQO
</term>
<listitem>
<para>
-Determines whether right-hand plan evaluation is allowed:
+<firstterm>Key Set Query Optimizer</firstterm> forces the query optimizer
+to optimize repetative OR clauses such as generated by
+<productname>MicroSoft Access</productname>:
<variablelist>
<varlistentry>
@@ -388,7 +391,7 @@ On
</term>
<listitem>
<para>
-enables right-hand evaluation of plans.
+enables this optimization.
<varlistentry>
<term>
@@ -396,7 +399,7 @@ Off
</term>
<listitem>
<para>
-disables right-hand evaluation of plans.
+disables this optimization.
<varlistentry>
<term>
@@ -404,7 +407,7 @@ DEFAULT
</term>
<listitem>
<para>
-Equivalent to specifying <command>SET R_PLANS=Off</command>.
+Equivalent to specifying <command>SET KSQO='off'</command>.
</variablelist>
<para>
@@ -430,7 +433,8 @@ Value
</term>
<listitem>
<para>
-Maximum number of rows to return for a query. The default is unlimited.
+Maximum number of rows to return for a query. The default is to allow
+an unlimited number of rows.
<varlistentry>
<term>
<replaceable class="parameter">#</replaceable>
@@ -445,12 +449,12 @@ DEFAULT
</term>
<listitem>
<para>
-Sets the number of rows returned by a query to unlimited.
+Sets the maximum number of rows returned by a query to be unlimited.
</varlistentry>
<para>
- By default, there is no limit to the number of rows
- returned by a query.
+By default, there is no limit to the number of rows
+returned by a query.
</variablelist>
</VARLISTENTRY>