The following bug has been logged online:
Bug reference: 1555
Logged by: Peter Cottingham
Email address: cottingh@rci.rutgers.edu
PostgreSQL version: 7.4.7-3.FC3.1
Operating system: Linix
Description: bug in GROUP BY?
Details:
Appears that the GROUP BY clause is not working correctly on new server
(GROUP BY should order the result set in ASCENDING order, NOT DESCENDING
order.) See below
**********************************
select dom_id, count(ste_id) as ste_count
from ste
group by dom_id
**********************************
ERRONEOUS RESULT SET:
dom_id ste_count
-----------
5 4
3 12
2 50
1 53