Re: [SQL] Ordering a date_part() query ...

On Tue, 18 Jan 2000, Tom Lane wrote:

> The Hermit Hacker <scrappy@hub.org> writes:
> >> Uh, why don't you just GROUP BY and ORDER BY stat_period?
> 
> > Okay, maybe I'm misunderstanding GROUP BY, but my understanding is that it
> > groups "like" values ... my above example would give me a count of all
> > impressions received over a one hour period ...
> 
> Oh, so "stat_period" is not a period label but an exact timestamp,
> and you want to group into hourly blocks?  OK, then group/order by
> date_trunc("hour", stat_period) is probably what you want...

good, ya had me worried I missed something in the docs on this one :)

> I'd suggest choosing another name for the field, too ;-)

*grin* I'm the only one that accesses it, so it doesn't much matter 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org