Message-ID: <4476D0D7.1080006@silversphere.co.za>
Date: Fri, 26 May 2006 11:56:39 +0200
From: James Neethling <james@silversphere.co.za>
Reply-To: pgsql-performance@postgresql.org
User-Agent: 1.5 (X11/20060309)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: column totals
Content-Type: multipart/mixed; boundary="------------040003010701040104030006"

This is a multi-part message in MIME format.
--------------040003010701040104030006
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi There,

I've got a situation where I need to pull profit information by product 
category, as well as the totals for each branch.

Basically, something like

SELECT branch_id, prod_cat_id, sum(prod_profit) as prod_cat_profit
    FROM () as b1
WHERE x = y
GROUP BY branch, prod_cat_id


Now, I also need the branch total, effectively,
SELECT branch_id, sum(prod_profit) as branch_total
    FROM () as b1
WHERE x = y
GROUP BY branch_id.


Since the actual queries for generating prod_profit are non-trivial, how 
do I combine them to get the following select list?

Or is there a more efficient way?

Kind Regards,
James


--------------040003010701040104030006
Content-Type: text/x-vcard; charset=utf-8;
 name="james.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="james.vcf"

begin:vcard
fn:James  Neethling
n:Neethling;James 
org:Silver Sphere Business Solutions
adr:Centurion Business Park A2;;25633 Democracy Way;Prosperity Park;Milnerton;Cape Town;7441
email;internet:james@silversphere.co.za
title:Managing Member
tel;work:27 21 552 7108
tel;fax:27 21 552 7106
tel;cell:27 83 399 2799
x-mozilla-html:FALSE
url:http://www.silversphere.co.za
version:2.1
end:vcard


--------------040003010701040104030006--