How would I format the following query?
select to_char(datetime,'-MM-DD') as date,url,sum(number_requests)
from request group by date,url order by date,url;
I have tried several different iterations, but the "as date" seems to
trip me up.
Any help would be appreciated, thanks.
___
I have noticed this same behavior using Class::DBI with Postgres.
-Original Message-
From: Toby Corkindale [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 9:52 AM
To: dbix-class@lists.rawmode.org
Subject: Re: [Dbix-class] Memory usage, something hanging on?
On Mon, Jan 08, 20
ember 28, 2006 3:37 PM
To: dbix-class@lists.rawmode.org
Subject: Re: [Dbix-class] A problem with Postgres schemas
--- Brandon Black <[EMAIL PROTECTED]> wrote:
> On 12/28/06, Kevin Esteb <[EMAIL PROTECTED]> wrote:
> > I new to DBIx::Class, so please bear with me.
> >
> &
Class::DBI didn't complain when I
used that syntax. So, just a newbie mistake.
-Original Message-
From: John Napiorkowski [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 28, 2006 1:15 PM
To: dbix-class@lists.rawmode.org
Subject: Re: [Dbix-class] A problem with Postgres schemas
I new to DBIx::Class, so please bear with me.
I am running RHEL4 and have a postgres database with a schema named
"analog". The DBIx::Class modules are the latest and greatest from CPAN,
so is the DBD and the DBI for postgres. When I run the below code, I get
this error:
DBIx::Class::Schema::res
