Home > mailing lists

Re: sum(bool)? - Mailing list pgsql-sql

From	Tod McQuillin
Subject	Re: sum(bool)?
Date	February 23, 2001 14:02:45
Msg-id	Pine.GSO.4.31.0102230941300.13223-100000@sysadmin Whole thread Raw
In response to	sum(bool)? (Olaf Zanger <olaf.zanger@soli-con.com>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Daniel Wickstrom
Date: 23 February 2001, 13:59:04
Subject: sum(bool)?

From: Peter Eisentraut
Date: 23 February 2001, 14:13:57
Subject: Re: sum(bool)?

Re: sum(bool)? - Mailing list pgsql-sql

Previous

Next