Home > mailing lists

sum(bool)? - Mailing list pgsql-sql

From	Olaf Marc Zanger
Subject	sum(bool)?
Date	February 24, 2001 13:55:46
Msg-id	01022316220800.01026@sino Whole thread Raw
Responses	Re: sum(bool)? ("Oliver Elphick" <olly@lfix.co.uk>)
List	pgsql-sql

Tree view

hi there,

i want to add up the "true" values of a comparison like

sum(a>b)

it just doesn't work like this

any workaround?

it is postgresql 7.0 under linux

thanks

olaf



-- 
soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23, 3013 Bern / Switzerland
fon:+41-31-332 9782, mob:+41-76-572 9782
mailto:olaf.zanger@soli-con.com, http://www.soli-con.com

pgsql-sql by date:

From: Olaf Marc Zanger
Date: 24 February 2001, 13:55:44
Subject: a tricky one

From: Tod McQuillin
Date: 24 February 2001, 13:59:26
Subject: Re: syntax prob

sum(bool)? - Mailing list pgsql-sql

Previous

Next