Omar Eljumaily <[EMAIL PROTECTED]> writes:
> Ted, my reason for asking the question that I believe precipitated this thread
> was that I wanted a single sql statement that aggregated time data by week.
> Yes, I could do the aggregation subsequently in my own client side code, but
> it's easier and less error prone to have it done by the server.
If you work closer to the data you have more efficiency. To do what you want
you can write a function using plpgsql -- I've posted some ideas -- and that
is not hard at all.
But if there was something to make it easier to write this it would be great ;-)
--
Jorge Godoy <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
