The following bug has been logged online: Bug reference: 1555 Logged by: Peter Cottingham Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])