[Please reply to the list so that others may benefit from and participate in the discussion.]

On Jun 18, 2007, at 11:32 , Ranieri Mazili wrote:

Thanks a lot for your prompt reply.
You query is perfect for my problem, but I need another thing with it, I need to return the sum of production_hours of each month of the current year, and I need to return too the average of the 3 past years, can I do all in only one query or I need to do a UNION with another query?

Glad you found it helpful. What have you tried so far?

Michael Glaesemann
grzm seespotcode net



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to