Re: How to GROUP results BY month - Mailing list pgsql-sql

From Mark Roberts
Subject Re: How to GROUP results BY month
Date
Msg-id 1216225787.26739.225.camel@localhost
Whole thread Raw
In response to Re: How to GROUP results BY month  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
On Wed, 2008-07-16 at 07:39 +0200, A. Kretschmer wrote:
> am  Tue, dem 15.07.2008, um 18:15:07 -0700 mailte Mark Roberts
> folgendes:
> > 
> > On Tue, 2008-07-15 at 14:31 +0200, A. Kretschmer wrote:
> > > am  Tue, dem 15.07.2008, um 13:12:39 +0100 mailte Oliveiros
> Cristina folgendes:
> > > > Howdy, all,
> > > > 
> > > > I have a problem.
> > > > 
> > > > I have a table which one of the fields is of type date.
> > > > 
> > > > I need to obtain the totals of the other fields in a  by-month
> basis
> > > > IS there any easy way to do this using the GROUP BY or any other
> construct?
> > > 
> > > ... group by extract(month from date)
> > > 
> > > 
> > > Andreas
> > 
> > It's worth noting that extract(month from timestamp) returns a
> month_no, and thus will not be suitable for grouping queries that span
> years.
> 
> Right, but that wasn't the question...

Honestly, the way the question was phrased, I'd have assumed that it
wanted to group by month (not group by a group of months).  Jan 08 is
distinct from Jan 07.

Please accept my sincerest apologies if you you feel that I
misinterpreted the question.  I was merely trying to illustrate the
difference between what each approach was.

-Mark



pgsql-sql by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: Rollback in Postgres
Next
From: Steve Midgley
Date:
Subject: Re: Problem with ORDER BY and DISTINCT ON