Received: from imr1.ericy.com (imr1.ericy.com [208.237.135.240]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NFjhx52410 for ; Fri, 23 Feb 2001 10:45:43 -0500 (EST) (envelope-from danw@netmanager7.rtp.ericsson.se) Received: from mr3.exu.ericsson.se (mr3u3.ericy.com [208.237.135.126]) by imr1.ericy.com (8.10.2/8.10.2) with ESMTP id f1NFjRr18153 for ; Fri, 23 Feb 2001 09:45:29 -0600 (CST) Received: from eamrcnt749 (eamrcnt749.exu.ericsson.se [138.85.133.47]) by mr3.exu.ericsson.se (8.10.2/8.10.2) with SMTP id f1NFjR202518 for ; Fri, 23 Feb 2001 09:45:27 -0600 (CST) Received: FROM netmanager7.rtp.ericsson.se BY eamrcnt749 ; Fri Feb 23 09:46:48 2001 -0600 Received: from satdsp14.ericsson.COM (satdsp14.rtp.ericsson.se [147.117.84.7]) by netmanager7.rtp.ericsson.se (8.8.8+Sun/8.6.4) with ESMTP id KAA20455 for ; Fri, 23 Feb 2001 10:45:24 -0500 (EST) Received: (from danw@localhost) by satdsp14.ericsson.COM (8.9.1b+Sun/8.9.1) id KAA00080; Fri, 23 Feb 2001 10:45:22 -0500 (EST) From: Daniel Wickstrom MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14998.34183.16811.538101@gargle.gargle.HOWL> Date: Fri, 23 Feb 2001 10:45:11 -0500 (EST) To: pgsql-sql@postgresql.org Subject: sum(bool)? In-Reply-To: <3A9681AD.55A3F355@soli-con.com> References: <3A9681AD.55A3F355@soli-con.com> X-Mailer: VM 6.72 under 21.1 (patch 10) "Capitol Reef" XEmacs Lucid X-Archive-Number: 200102/358 X-Sequence-Number: 1554 >>>>> "Olaf" == Olaf Zanger writes: Olaf> hi there i'd like to add up the "true" values of a Olaf> comparison like Olaf> sum(a>b) Olaf> it just doesn't work like this Olaf> any workaround Try using a case statement: select sum(case when a > b then 1 else 0 end) .... -Dan