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