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] COPY equivalent for updates

2008-07-15 Thread Decibel!
On Jul 15, 2008, at 1:10 AM, Ivan Sergio Borgonovo wrote: I'd like to UPDATE t1 (col1, col2, col3) from file with @1 as primary key; or UPDATE t1 (col1, col2, col3) from file where @1=id; sort of... Sorry, there's nothing like COPY for UPDATE. Otherwise what is the fastest approach? I can

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] Rollback in Postgres

2008-07-15 Thread Jonah H. Harris
On Tue, Jul 15, 2008 at 2:17 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: > I agree such improvements would be welcomed. I'm pretty sure they sat > around saying we can already do that some other way at first, until the > requests started to pile up. Agreed. > >> > Stuff that they see fit to add is

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