On Tue, Jul 15, 2008 at 6:12 AM, Oliveiros Cristina
> 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?
In addition to the responses on grouping by extract('month' from
timestamp) you can also index on this function as long as timestamp
isn't timestamp with timezone. With that index in place, grouping by
month can be pretty fast even for large datasets covering many months.
In response to
pgsql-sql by date
|Next:||From: Mark Roberts||Date: 2008-07-16 01:15:07|
|Subject: Re: How to GROUP results BY month|
|Previous:||From: Jonah H. Harris||Date: 2008-07-15 13:59:22|
|Subject: Re: Rollback in Postgres|