Re: count and limit

Fabio Victora Hecht wrote:
> Hi!
>
> I've been using Postgresql for a while now and I'm very satisfied.
>
> I was wondering if there's a way to count the results of a query and
> return part of the result set it in one query (LIMIT). Because I usually
> have to count the results using one query (to tell the user how many
> records match the criteria) and show the first 20 records.

I was going to suggest a cursor but I don't think you can get the number
of results a cursor has :(

--
Postgresql & php tutorials
http://www.designmagick.com/