DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding;
	b=o6w41RwrOlGqzaHwAvubDHyRRoCFMrN4YV9Gi7ikNaM379L6FSfuVHORgo8+eDAQ7ssvBqPh8EYbhIdo0m0ZczJM34Nf6FfHykPrtN0j3je13AEhS5QXa32DWLrWuDI4f1XRoWkqLY5jkDXNMULrlLYt4FrWkKcKDX5L7QZpmRE=
Message-ID: <470A0B20.40203@gmail.com>
Date: Mon, 08 Oct 2007 12:49:04 +0200
From: =?ISO-8859-1?Q?Dani_Casta=F1os?= <danitao.mailists@gmail.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Get different sums from the same table in one query
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi all!

I want to put this three queries in only one... Take a look that the 
only thing that changes is the message_type_id. Any suggestions??

         SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)
         FROM statistics_daily
         WHERE message_type_id IN (4,5)
         AND statistics_date = CURRENT_DATE
         AND telecom_operator_id <> 0
         AND telephone_number IN ( $numbers )
         GROUP BY date_in

         SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)
         FROM statistics_daily
         WHERE message_type_id IN (6)
         AND statistics_date = CURRENT_DATE
         AND telecom_operator_id <> 0
         AND telephone_number IN ( $numbers )
         GROUP BY date_in

         SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)
         FROM statistics_daily
         WHERE message_type_id IN (21)
         AND statistics_date = CURRENT_DATE
         AND telecom_operator_id <> 0
         AND telephone_number IN ( $numbers )
         GROUP BY date_in


Thank you in advance!