Re: timestamp group by bug???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Celia McInnis" <celia(at)drmath(dot)ca>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: timestamp group by bug???
Date: 2005-03-21 17:56:52
Message-ID: 467.1111427812@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Celia McInnis" <celia(at)drmath(dot)ca> writes:
> Help - I'm not sure if this is a bug, but I wouldn't call it a feature! :-)

Hardly a bug ... you told it to order by a textual value, why
would you expect a non-alphabetical sort ordering?

I would suggest ordering by EXTRACT(DOW FROM mytimestamp).
You'll probably have to list that as a second GROUP BY item in order
to make Postgres happy with the query.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Walker, Jed S 2005-03-21 20:47:43 .pgpass file
Previous Message Celia McInnis 2005-03-21 17:36:42 timestamp group by bug???