I wonder if this could be implemented using the window-function infrastructure...
...Robert On Sun, Oct 12, 2008 at 9:07 AM, Grzegorz Jaskiewicz <[EMAIL PROTECTED]> wrote: > that's a shame. > I figure, with the "WITH ... AS .." you can kind of speed up counts, just by > doing it once - now. But still, it would be great to be able to use PERCENT, > against estimate. > After all, imagine a table FOO with 5 rows, and something like this: > > WITH c AS (select count(*)/4 as n from FOO) select * from FOO limit (select > n from c) offset (select n*X from c); > > now X is for every 25%, but you wan't get to see last row if you use offset > 75 percent (X=3). Which kind of puts me off the idea of using PERCENT > anyway, because it isn't quite accurate. > > So thanks for answer, I'll pass on this one. Hopefully there would be > another chance for me to write some patch in future. > > ta. > > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
