| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Ranieri Mazili <ranieri(dot)oliveira(at)terra(dot)com(dot)br> |
| Cc: | postgresql sql list <pgsql-sql(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] Setting Variable - (Correct) |
| Date: | 2007-06-18 16:50:46 |
| Message-ID: | 2D977EAC-654B-44F5-AB1F-336031F6466D@seespotcode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
[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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2007-06-18 17:02:39 | Re: [PERFORM] Postgres VS Oracle |
| Previous Message | Andreas Kostyrka | 2007-06-18 16:50:15 | Re: [PERFORM] Postgres VS Oracle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ranieri Mazili | 2007-06-18 17:11:59 | Re: [SQL] Setting Variable - (Correct) |
| Previous Message | Ranieri Mazili | 2007-06-18 16:41:25 | Re: [SQL] Setting Variable - (Correct) |