Returning number of matches on a query when using limit

Started by Mohamedabout 17 years ago2 messagesgeneral
Jump to latest
#1Mohamed
mohamed5432154321@gmail.com

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

#2Reg Me Please
regmeplease@gmail.com
In reply to: Mohamed (#1)
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