Message-ID: <470A1665.6030500@archonet.com>
Date: Mon, 08 Oct 2007 12:37:09 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.6 (X11/20070728)
MIME-Version: 1.0
To: =?ISO-8859-1?Q?Dani_Casta=F1os?= <danitao.mailists@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Get different sums from the same table in one query
References: <470A0B20.40203@gmail.com>
In-Reply-To: <470A0B20.40203@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Dani Casta=F1os wrote:
> Hi all!
>=20
> I want to put this three queries in only one... Take a look that the=20
> only thing that changes is the message_type_id. Any suggestions??
>=20
>         SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,=20
> sum(total_num_messages)
>         FROM statistics_daily
>         WHERE message_type_id IN (4,5)
>         AND statistics_date =3D CURRENT_DATE
>         AND telecom_operator_id <> 0
>         AND telephone_number IN ( $numbers )
>         GROUP BY date_in

Is this what you mean?

SELECT message_type_id, to_char...
...
WHERE message_type_id IN (4,5,6,21)
...
GROUP BY message_type_id, date_id


--=20
   Richard Huxton
   Archonet Ltd