"order by" and "order by asc" returning different results on date field

From: Rick Gentry <rick(dot)gentry(at)zenus-biometrics(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: "order by" and "order by asc" returning different results on date field
Date: 2018-05-15 18:25:47
Message-ID: CAF0U+Fk1Stx=cGR3FajEAH7+9bRRUVj3t=WHKQdt_EVFyOb3iQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have a table that I'm using to log results from my system. It has a
field "created timestamp default current_timestamp."

Running the query "select * from tbl_log order by created asc;" works as
expected.

Running the query "select * from tbl_log order by created;" returns sorted
chunks of 2000 records.

Regards,
Rick Gentry
-----------------
Zenus, Inc.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-05-15 18:59:53 Re: "order by" and "order by asc" returning different results on date field
Previous Message Tom Lane 2018-05-15 16:52:12 Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution