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 <[EMAIL PROTECTED]>
���� : [EMAIL PROTECTED] <[EMAIL PROTECTED]>
���� : 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'
>
>
>
>
