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

Поиск
Список
Период
Сортировка
От Rick Gentry
Тема "order by" and "order by asc" returning different results on date field
Дата
Msg-id CAF0U+Fk1Stx=cGR3FajEAH7+9bRRUVj3t=WHKQdt_EVFyOb3iQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: "order by" and "order by asc" returning different results on date field
Список 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.

В списке pgsql-bugs по дате отправления: