Received: from sysadmin.chi.wdr.com (sysadmin.chi.ubswarburg.com [146.180.1.66]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NFhYx52060 for ; Fri, 23 Feb 2001 10:43:34 -0500 (EST) (envelope-from devin@sysadmin.chi.wdr.com) Received: from devin by sysadmin.chi.wdr.com with local (Exim 3.12 #2) id 14WKNP-0003Ra-00; Fri, 23 Feb 2001 09:43:23 -0600 Date: Fri, 23 Feb 2001 09:43:21 -0600 (CST) From: Tod McQuillin X-X-Sender: To: Olaf Zanger cc: Subject: Re: sum(bool)? In-Reply-To: <3A9681AD.55A3F355@soli-con.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/359 X-Sequence-Number: 1555 On Fri, 23 Feb 2001, Olaf Zanger wrote: > i'd like to add up the "true" values of a comparison like > > sum(a>b) > > it just doesn't work like this Try sum(case when a>b then 1 else 0 end) -- Tod McQuillin