Re: [SQL] Setting Variable - (Correct) - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: [SQL] Setting Variable - (Correct)
Date
Msg-id 2D977EAC-654B-44F5-AB1F-336031F6466D@seespotcode.net
Whole thread Raw
In response to Setting Variable - (Correct)  (Ranieri Mazili <ranieri.oliveira@terra.com.br>)
Responses Re: [SQL] Setting Variable - (Correct)  (Ranieri Mazili <ranieri.oliveira@terra.com.br>)
List pgsql-general
[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



pgsql-general by date:

Previous
From: Andreas Kostyrka
Date:
Subject: Re: [PERFORM] [ADMIN] Postgres VS Oracle
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [PERFORM] [ADMIN] Postgres VS Oracle