| From: | Bret Hughes <bhughes(at)elevating(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | group by not returning sorted rows |
| Date: | 2004-04-05 21:55:42 |
| Message-ID: | 1081202143.18380.117.camel@bretsony |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a query:
select cities.name as city, buildings.name as building,
pagename,
log_date ,
sum(exhibition_count) as tot
from logrecords
join cities on (logrecords.city=cities.num)
join buildings on (logrecords.building=buildings.num)
where advertiser = 'Nielsens' and
log_date >= '01/01/2004' and
log_date <= '01/31/2004'
group by cities.name, buildings.name,pagename,log_date ;
I have migrated a database from a redhat 7.3 box running
[bhughes(at)compaq3 reports]$ rpm -q postgresql
postgresql-7.2.3-5.73
To a redhat 9 box running :
[bhughes(at)compaq2 reports]$ rpm -q postgresql
postgresql-7.4.2-1PGDG
and the rows resulting from the query are no longer sorted by log date.
Is this a change since 7.2x?
I can achieve the results I need by adding an order by clause identical
to the group by but this seems counter intuitive since the rows have to
be ordered anyway.
Any tips appreciated.
Bret
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2004-04-05 22:33:02 | Re: Entered data appears TWICE in table!!? |
| Previous Message | Tom Lane | 2004-04-05 17:39:28 | Re: Function To Log Changes |