Re: [GENERAL] Returning number of matches on a query when using limit

2009-01-13 Thread Reg Me Please 
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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Returning number of matches on a query when using limit

2009-01-13 Thread Mohamed 
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