diff options
author | Thomas G. Lockhart | 1998-10-14 16:31:28 +0000 |
---|---|---|
committer | Thomas G. Lockhart | 1998-10-14 16:31:28 +0000 |
commit | 6129de0b76005d22e87704bf174ee2122f42a4ee (patch) | |
tree | 39414f77f18329df87c3b153a3d66e9ef60ca6e0 | |
parent | 963ed0e72ae532bf6699d32dbae3c21ec205754b (diff) |
Remove duplicate entry for R_PLAN (thanks Bruce).
Add entry for undocumented (?) KSQO.
-rw-r--r-- | doc/src/sgml/ref/set.sgml | 46 |
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> |