On Tue, Mar 26, 2019 at 5:46 PM Tomas Vondra <tomas.von...@2ndquadrant.com> wrote:
> On Tue, Mar 26, 2019 at 03:06:52PM +0300, Surafel Temesgen wrote: > > As for the OFFSET, I don't see why that would be incompatible with PERCENT > clause. I'm not sure if it should compute the percentage from the total > number of rows (including those skipped by the OFFSET) or the rest, but I > assume SQL standard says something about that. > > I check SQL standard and it is different in PERCENT cause. It state that the percentage is computed using the number of rows before removing the rows specified by offset row count regards Surafel
