Re: [SQL] How to GROUP results BY month

2008-07-18 Thread Oliveiros Cristina
Still another way to do :-) Thanks, Lennin. Best, Oliveiros - Original Message - From: "Lennin Caro" <[EMAIL PROTECTED]> To: ; "A. Kretschmer" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2008 3:04 PM Subject: Re: [SQL] How to GROUP results BY month

Re: [SQL] How to GROUP results BY month

2008-07-18 Thread Lennin Caro
i think this work select id,count from table group by to_char(date,'MM') --- On Wed, 7/16/08, A. Kretschmer <[EMAIL PROTECTED]> wrote: > From: A. Kretschmer <[EMAIL PROTECTED]> > Subject: Re: [SQL] How to GROUP results BY month > To: pgsql-sql@postgresql.org >

Re: [SQL] How to GROUP results BY month

2008-07-17 Thread Oliveiros Cristina
tips on indexing Again, thanks a lot. Best, Oliveiros - Original Message - From: "Mark Roberts" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, July 16, 2008 5:29 PM Subject: Re: [SQL] How to GROUP results BY month On Wed, 2008-07-16 at 07:39 +0200, A. Kretschmer wrot

Re: [SQL] How to GROUP results BY month

2008-07-16 Thread Mark Roberts
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: > > > > How

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread A. Kretschmer
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 tabl

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread A. Kretschmer
am Tue, dem 15.07.2008, um 15:57:54 -0600 mailte Scott Marlowe folgendes: > On Tue, Jul 15, 2008 at 6:12 AM, Oliveiros Cristina > <[EMAIL PROTECTED]> wrote: > > 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

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread Scott Marlowe
On Tue, Jul 15, 2008 at 7:15 PM, Mark Roberts <[EMAIL PROTECTED]> wrote: > > 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

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread Mark Roberts
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

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread Scott Marlowe
On Tue, Jul 15, 2008 at 6:12 AM, Oliveiros Cristina <[EMAIL PROTECTED]> wrote: > 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

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread Herouth Maoz
Oliveiros Cristina wrote: 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? Yes, use date_trunc( 'month', time

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread Herouth Maoz
Oliveiros Cristina wrote: 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? Yes, use date_trunc( 'month', time

Re: [SQL] How to GROUP results BY month

2008-07-15 Thread A. Kretschmer
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 GR

[SQL] How to GROUP results BY month

2008-07-15 Thread 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? Thanks in advance for your kind help Best, Oliveiros -- Sent