From: Michael Glaesemann <grzm@seespotcode.net>
To: Ranieri Mazili <ranieri.oliveira@terra.com.br>
Cc: postgresql sql list <pgsql-sql@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: [SQL] Setting Variable - (Correct)
Date: Mon, 18 Jun 2007 11:50:46 -0500
Message-ID: <2D977EAC-654B-44F5-AB1F-336031F6466D@seespotcode.net> (raw)
In-Reply-To: <4676B38A.303@terra.com.br>
References: <467697ED.8030506@terra.com.br>
<108B61B7-DB9A-4FE3-832C-323866956DFE@seespotcode.net>
<7DA5333D-3437-4033-A222-128E541A04C2@seespotcode.net>
<4676B38A.303@terra.com.br>
[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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@seespotcode.net, ranieri.oliveira@terra.com.br, pgsql-general@postgresql.org
Subject: Re: [SQL] Setting Variable - (Correct)
In-Reply-To: <2D977EAC-654B-44F5-AB1F-336031F6466D@seespotcode.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox