RE: [GENERAL] LIMIT QUESTION

This is from the Tutorial for version 6.4 of PostgreSQL.

SET - Set run-time parameters for session

SET variable { TO | = } { 'value' | DEFAULT }
SET TIME ZONE { 'timezone' | LOCAL };

QUERY_LIMIT
Sets the number of rows returned by a query.
Value
Maximum number of rows to return for a query. The default is
to allow an unlimited number of rows.
#
Sets the maximum number of rows returned by a query to #.
DEFAULT
Sets the maximum number of rows returned by a query to be
unlimited.
By default, there is no limit to the number of rows returned by a
query.

On Thu, 29 Apr 1999, Martin Wong wrote:

> Sorry for the previous posting. The following worked.
>
> BTW, this affects just this database or throughout the entire postgresql
> server?
>
> And, how does one reset this variable to max?
>
> Thanks
>
> martin
>
> This works in 6.4.2:
>
> set QUERY_LIMIT TO '10'; or
> set QUERY_LIMIT = '10';
>