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

Поиск
Список
Период
Сортировка
От Reg Me Please
Тема Re: Returning number of matches on a query when using limit
Дата
Msg-id 200901132204.11770.regmeplease@gmail.com
обсуждение исходный текст
Ответ на Returning number of matches on a query when using limit  (Mohamed <mohamed5432154321@gmail.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Mohamed
Дата:
Сообщение: Returning number of matches on a query when using limit
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cast for text->Integer missing in 8.3.5