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

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: (view raw, whole thread or download thread mbox)
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


pgsql-novice by date

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

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