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-----
差出人 : Margarita Barvinok <[EMAIL PROTECTED]>
宛先 : [EMAIL PROTECTED] <[EMAIL PROTECTED]>
日時 : 1999年4月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'
>
>
>
>