Skip site navigation (1) Skip section navigation (2)

RE: [GENERAL] LIMIT QUESTION

From: "Martin Wong" <martin(at)minook(dot)com(dot)sg>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] LIMIT QUESTION
Date: 1999-04-29 14:22:26
Message-ID: 00b401be924b$b50bbb40$6500a8c0@martin (view raw or flat)
Thread:
Lists: 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(at)math(dot)lsa(dot)umich(dot)edu>
ˆ¶æ : pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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'
>
>
>
>






Responses

pgsql-general by date

Next:From: Margarita BarvinokDate: 1999-04-29 14:36:11
Subject: Re: [GENERAL] LIMIT QUESTION
Previous:From: Martin WongDate: 1999-04-29 14:20:27
Subject: RE: [GENERAL] LIMIT QUESTION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group