Re: Views and functions returning sets of records

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Rajashri Tupe <rajashrivtupe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Views and functions returning sets of records
Date: 2008-04-11 07:23:36
Message-ID: 47FF11F8.3090805@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2008-04-11 10:41:15 Re: Partitioned tables - planner wont use indexes
Previous Message Chris 2008-04-11 05:11:34 Re: Creating large database of MD5 hash values