[SQL] Time Aggregates

[Itai Zukerman]

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