Time Aggregates - Mailing list pgsql-sql

From Itai Zukerman
Subject Time Aggregates
Date
Msg-id 87ittju6e7.fsf@matt.w80.math-hat.com
Whole thread Raw
List pgsql-sql
Hi,

I'm currently doing this:
 SELECT symbol, date_trunc('minute', posted),        min(price), max(price), avg(price) FROM trade GROUP BY symbol,
date_trunc('minute',posted);
 

to get a list of minute-averages of trade prices.  I get the feeling
that this is bad form, that I should be doing this some other way.  Is
that the case?

-itai


pgsql-sql by date:

Previous
From: Jon Lapham
Date:
Subject: Re: on line numbers, drop table errors, and log files
Next
From: Thomas Lockhart
Date:
Subject: Re: Time Aggregates