Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA28344; Thu, 18 Mar 93 09:02:15 -0800
Message-Id: <9303181702.AA28344@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: restrict the no. of record retrieved
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 18 Mar 93 19:00:24 PST.
             <9303181100.AA26873@postgres.Berkeley.EDU> 
Date: Thu, 18 Mar 93 09:01:29 PST

In message <9303181100.AA26873@postgres.Berkeley.EDU> you write:

> I am using the postgres 4.0.1 on Sun Sparc. I wonder if there is a way
> to restrict the no. of record retrieved from a table. If the no. of
> record retrieved is huge, we will encounter the buffer overflow problem.

see the manual for information on portals.  you can do

	retrieve portal p (foo.all)
	fetch 10 in p
	...

					mike