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