Re: Views and functions returning sets of records - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Views and functions returning sets of records
Date
Msg-id 47FF11F8.3090805@postnewspapers.com.au
Whole thread Raw
In response to Re: Views and functions returning sets of records  (Rajashri Tupe <rajashrivtupe@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Performance is low Postgres+Solaris
Next
From: PFC
Date:
Subject: Re: Partitioned tables - planner wont use indexes