Re: Count for pagination

> Any suggestions on how to get the count of all records that could be
> returned

We use a window function to get the total # of records within each of 
our paginated queries:

SELECT
   ...
   ,COUNT(*) OVER() fullRowCount
FROM ...
WHERE ...
ORDER BY ...
LIMIT ... OFFSET ...;


While there is a cost to using the window  function, it's faster (for 
us) than two separate queries, and, more importantly, it's flexible 
enough to work in the 100s of different query contexts we have.

/mcr