<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>

</variablelist>

<para>

The possible variables and allowed values are:

The possible variables and allowed values are:

<VARIABLELIST>

<VARLISTENTRY>

</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>

</term>

<listitem>

<para>

Equivalent to specifying <command>SET GEQO=On</command>

Equivalent to specifying <command>SET GEQO='on'</command>

</varlistentry>

</variablelist>

</term>

<listitem>

<para>

Equivalent to specifying <command>SET R_PLANS=Off</command>.

Equivalent to specifying <command>SET R_PLANS='off'</command>.

</variablelist>

<para>

<varlistentry>

<term>

</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>

</term>

<listitem>

<para>

enablesright-hand evaluation of plans.

enablesthis optimization.

<varlistentry>

<term>

Off

</term>

<listitem>

<para>

disablesright-hand evaluation of plans.

disablesthis optimization.

<varlistentry>

<term>

DEFAULT

</term>

<listitem>

<para>

Equivalent to specifying <command>SETR_PLANS=Off</command>.

Equivalent to specifying <command>SETKSQO='off'</command>.

</variablelist>

<para>

</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>

</term>

<listitem>

<para>

Sets the number of rows returned by a query to unlimited.

Sets themaximumnumber 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>