Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2B4B12E003D for ; Fri, 11 Apr 2008 04:24:10 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54980-02 for ; Fri, 11 Apr 2008 04:24:03 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by developer.postgresql.org (Postfix) with ESMTP id A6AAD2E002F for ; Fri, 11 Apr 2008 04:24:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [202.61.230.242]) by mx1.hub.org (Postfix) with ESMTP id 8B499B07FEB for ; Fri, 11 Apr 2008 04:24:01 -0300 (ADT) Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by www.postnewspapers.com.au (Postfix) with ESMTP id 7CCEAD55D7; Fri, 11 Apr 2008 15:23:50 +0800 (WST) Received: from localhost (access [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 4669F1E0436; Fri, 11 Apr 2008 15:23:53 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id tR74yjeUkJlM; Fri, 11 Apr 2008 15:23:51 +0800 (WST) Received: from [203.161.97.213] (203.161.97.213.static.amnet.net.au [203.161.97.213]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTP id 7C6371E0435; Fri, 11 Apr 2008 15:23:51 +0800 (WST) Message-ID: <47FF11F8.3090805@postnewspapers.com.au> Date: Fri, 11 Apr 2008 15:23:36 +0800 From: Craig Ringer User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Rajashri Tupe Cc: pgsql-performance@postgresql.org Subject: Re: Views and functions returning sets of records References: <6A737ADC-2A11-4A01-8ACE-C439E4297273@mac.com> <29705.1206203639@sss.pgh.pa.us> <20080322165551.GA19460@KanotixBox> <8000.1206286132@sss.pgh.pa.us> <47f1ca91-9877-419f-ad6a-f2d842980902@i36g2000prf.googlegroups.com> In-Reply-To: <47f1ca91-9877-419f-ad6a-f2d842980902@i36g2000prf.googlegroups.com> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/147 X-Sequence-Number: 29640 Rajashri Tupe wrote: > Can we write retrieving only 10 records from 4000 records > plz tell me asap > Is this question connected to the previous discussion? Can you be more specific with your question? Without having any idea what you're talking about, I'll direct you to the "LIMIT" clause of the SELECT statement in case that's what you mean. http://www.postgresql.org/docs/current/static/queries-limit.html -- Craig Ringer