On 8/12/16 at 7:51 AM, Krzysztof Otręba wrote:
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
Ditto, and similar ordering problems also happen when the
underlying field type is text derived from a table as opposed to
a generated numeric sequence.
PostgreSQL 9.4.5 on x86_64-apple-darwin
OSX 10.11.6
Regards
Gavan Schneider
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
