Returning number of matches on a query when using limit
Started by Mohamedabout 17 years ago2 messagesgeneral
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
Re: Returning number of matches on a query when using limit
On Tuesday 13 January 2009 21:56:56 Mohamed wrote:
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
... RETURNING COUNT(*)
--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand