Hi,
When I execute query like this:
SELECT generate_series(0, 999)
ORDER BY 1 ASC;
On first page I see rows 0-49, on second page 999-950 descending!,
last - 99-50 descending!
Should be:
- first page 0-49
- second 50-99
- next 100-149
- etc.
- page number 20: 950-999
Tested on:
- Fedora 24 x64 (commit 035066bd; Tue, 9 Aug 2016 15:23:24),
PostgreSQL 9.2, 9.3, 9.5
- Windows 7 x64; Pgadmin4 1.0-beta3; PostgreSQL 9.6beta4
Regards,
Krzysztof Otręba