Thread: RE: [GENERAL] LIMIT QUESTION

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
-----Original Message-----
·ol : Margarita Barvinok <brita@math.lsa.umich.edu>
ˆ¶æ : pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
“úŽž : 1999”N4ŒŽ30“ú 0:01
Œ–¼ : Re: [GENERAL] LIMIT QUESTION



This works in 6.4.2:

set QUERY_LIMIT TO '10';     or
set QUERY_LIMIT = '10';

On Thu, 29 Apr 1999, [iso-8859-1] José Soares wrote:

>
> Use SET QUERY_LIMT TO 10;
> this should work in 6.4.2
> ______________________________________________________________
> PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Jose'
>
>
>
>

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

Martin Wong ha scritto:

> Sorry for the previous posting. The following worked.
>
> BTW, this affects just this database or throughout the entire postgresql
> server?
>

Only current_session;

>
> And, how does one reset this variable to max?
>

RESET QUERY_LIMIT;

______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'