sum(bool)?

From: Olaf Marc Zanger <olaf(dot)zanger(at)soli-con(dot)com>
To: PgSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: sum(bool)?
Date: 2001-02-23 15:22:08
Message-ID: 01022316220800.01026@sino
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)zanger(at)soli-con(dot)com, http://www.soli-con.com

Browse pgsql-sql by date

  From Date Subject
Next Message Olaf Zanger 2001-02-23 15:28:45 sum(bool)?
Previous Message Tom Lane 2001-02-23 15:14:08 Re: insert values