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.
PGP.sig
Description: This is a digitally signed message part
