tricky date manipulations? - Mailing list pgsql-general

From Alfred Perlstein
Subject tricky date manipulations?
Date
Msg-id 20000406173527.J22104@fw.wintelcom.net
Whole thread Raw
Responses Re: tricky date manipulations?  (Frank Bax <fbax@execulink.com>)
List pgsql-general
I'm trying to accomplish some things where some tricky manipulation
of dates would be very helpful.

I'm wondering if it's possible to:

select from a table several records and group by a date column.

The idea is that I have a table with rows for each hour, I'd like
to be able to select a date range (let's say a month) and perform
sums on some of the columns however "group by" the day, so that I
get rows returned that are the sum of all the day's statistics for
several days.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-general by date:

Previous
From: Daniel Stolk
Date:
Subject: Re: large text fields
Next
From: Frank Bax
Date:
Subject: Re: tricky date manipulations?