Returning number of matches on a query when using limit

From: Mohamed <mohamed5432154321(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Returning number of matches on a query when using limit
Date: 2009-01-13 20:56:56
Message-ID: 861fed220901131256g4c7f728aoe613f62d50b0b133@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. How would I return the number of matches found by a query, but when I
only want to return 30 of them ?
In MySQL there is a way of calling SQL_CALC_FOUND_ROWS to do this?

Is there something similiar that can be done in PostgreSQL ? Do I have to
rerun my query?

Thanks / Moe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reg Me Please 2009-01-13 21:04:11 Re: Returning number of matches on a query when using limit
Previous Message Brad Balmer 2009-01-13 20:45:50 XPath to search for elements in a sequence