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
