Re: Pagination count strategies - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Pagination count strategies
Date
Msg-id 20140403160758.GJ58047@crankycanuck.ca
Whole thread Raw
In response to Re: Pagination count strategies  (Leonardo M. Ramé <l.rame@griensu.com>)
List 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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: COPY v. java performance comparison
Next
From: David Johnston
Date:
Subject: Re: window function help