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,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Fri, Mar 16, 2018 at 7:40 PM, Justin <zzzzz(dot)graf(at)gmail(dot)com> wrote:

> see attached picture.
>
> PGadmin the displayed data is not staying in desired sort order (order by
> date desc) per the SQL command ....
>
> The return set is around 4000 rows long, the two source tables are
> 14,000 and 251,340 rows
>
> 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
>
> Operating System Windows 7 64bit
>
>
>
>
>