RE: [GENERAL] LIMIT QUESTION - Mailing list pgsql-general

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