"order by" and "order by asc" returning different results on date field
Rick Gentry <rick.gentry@zenus-biometrics.com>
From: Rick Gentry <rick.gentry@zenus-biometrics.com>
To: pgsql-bugs@postgresql.org
Date: 2018-05-15T18:25:47Z
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.