On Tue, Jul 27, 2010 at 09:25:05PM -0400, Patrick May wrote:
> On Jul 27, 2010, at 9:21 PM, Steve Atkins wrote:
> > select date_trunc('hour', foo) + interval '30 minutes' *
> > floor(extract(minute from foo) / 30) as start, event, count(*) from bar
> > group by 1, 2 order by 1 asc;
>
> Tha
On Jul 27, 2010, at 9:21 PM, Steve Atkins wrote:
> On Jul 27, 2010, at 6:07 PM, Patrick May wrote:
>> On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
I have a table containing events with timestamps. I would like
to generate a histogram of the number of each type of event for each
>>>
On Jul 27, 2010, at 6:07 PM, Patrick May wrote:
> On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
>>> I have a table containing events with timestamps. I would like
>>> to generate a histogram of the number of each type of event for each
>>> half-hour period from 8:00 am to 6:00 pm. Are the
On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
>> I have a table containing events with timestamps. I would like
>> to generate a histogram of the number of each type of event for each
>> half-hour period from 8:00 am to 6:00 pm. Are there any tools that
>> will help me do this?
>
> GROUP
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Patrick May
> Sent: Tuesday, July 27, 2010 3:59 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Histogram generator
>
> Hi,
&
Hi,
I have a table containing events with timestamps. I would like to
generate a histogram of the number of each type of event for each half-hour
period from 8:00 am to 6:00 pm. Are there any tools that will help me do this?
Thanks,
Patrick
smime.p7s
Description: S/MIME cryptograp
