Skip site navigation (1) Skip section navigation (2)

BUG #1555: bug in GROUP BY?

From: "Peter Cottingham" <cottingh(at)rci(dot)rutgers(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1555: bug in GROUP BY?
Date: 2005-03-21 19:20:04
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1555
Logged by:          Peter Cottingham
Email address:      cottingh(at)rci(dot)rutgers(dot)edu
PostgreSQL version: 7.4.7-3.FC3.1
Operating system:   Linix
Description:        bug in GROUP BY?

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


dom_id  ste_count
5 4
3 12
2 50
1 53


pgsql-bugs by date

Next:From: Dennis van DokDate: 2005-03-21 21:06:49
Subject: BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment
Previous:From: Guido BarosioDate: 2005-03-21 17:22:02
Subject: BUG #1554: wrong character on the file

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group