Re: Pagination count strategies

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Pagination count strategies
Дата
Msg-id 20140403160758.GJ58047@crankycanuck.ca
обсуждение исходный текст
Ответ на Re: Pagination count strategies  (Leonardo M. Ramé <l.rame@griensu.com>)
Список pgsql-general
On Thu, Apr 03, 2014 at 12:44:23PM -0300, Leonardo M. Ramé wrote:
> Sounds nice, is it possible to modify my "count(*) over()" to what you
> suggest?.

I think the window_definition inside over() can contain a LIMIT, can't
it?  I didn't check just now, but I can't think any reason why not.
(ISTR when I did this in the past we didn't have window functions, so
I simulated it another way.)

A

--
Andrew Sullivan
ajs@crankycanuck.ca


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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: COPY v. java performance comparison
Следующее
От: David Johnston
Дата:
Сообщение: Re: window function help