Postgres Pro
Downloads
Home   >   mailing lists

"order by" and "order by asc" returning different results on date field - Mailing list pgsql-bugs

From Rick Gentry
Subject "order by" and "order by asc" returning different results on date field
Date
Msg-id CAF0U+Fk1Stx=cGR3FajEAH7+9bRRUVj3t=WHKQdt_EVFyOb3iQ@mail.gmail.com
Whole thread Raw
Responses Re: "order by" and "order by asc" returning different results on date field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution
Next
From: Tom Lane
Date:
Subject: Re: "order by" and "order by asc" returning different results on date field