Re: possible bug in PG admin
pgAdmin4 don't do any sorting by itself, it just displays what it receives from server.
Did you cross verify your output with psql?
I'm not able to re-produce the issue (attaching screenshot).
--
Regards,
On Fri, Mar 16, 2018 at 7:40 PM, Justin <zzzzz.graf@gmail.com> wrote:
Operating System Windows 7 64bitSQL commandThe return set is around 4000 rows long, the two source tables are 14,000 and 251,340 rowssee attached picture.PGadmin the displayed data is not staying in desired sort order (order by date desc) per the SQL command ....
select comment_id , item_id, item_number, item_descrip1, comment_text, comment_date, comment_user
from item, comment
where item_id = comment_source_id and comment_source = 'I'
and item_active and comment_text::char(10) = 'List Price'
and comment_date>= '2015-01-01'
order by comment_date desc
Вложения
В списке pgadmin-support по дате отправления: