From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
---|---|
To: | tom(at)haddons(dot)net |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Sum of Every Column |
Date: | 2002-10-23 21:13:03 |
Message-ID: | 3DB710DF.DE045069@nsd.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tom,
You can add
sum( case when <boolean_field> then 1 else 0 end)
for each field that you need.
JLL
Tom Haddon wrote:
>
> Hi Folks,
>
> I'm hoping to put together a query that generates a report on a table with
> a large number of boolean fields. This report has to be able to adapt to
> the number of fields in the table. Essentially, I want it to provide the
> sum of TRUE values for each field for a given subset of the table. I've
> got the query that returns the subset of the table (this is based on a
> relationship with another table):
>
> SELECT breast_cancer_resources.*
> FROM breast_cancer_resources, agency_contact_info
> WHERE breast_cancer_resources.id=agency_contact_info.id
> AND agency_contact_info.guideregion=1
> AND agency_contact_info.list_online=TRUE
>
> But I'm not sure how to generate the sum for each column. Should I be
> looking elsewhere than SQL to do this for me, such as php (this is for a
> web-based report)?
>
> Thanks, Tom
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-10-23 21:15:31 | Re: Sum of Every Column |
Previous Message | Tom Haddon | 2002-10-23 20:17:26 | Sum of Every Column |