"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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "order by" and "order by asc" returning different results on date field