sum(bool)?

From: Olaf Zanger <olaf(dot)zanger(at)soli-con(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: sum(bool)?
Date: 2001-02-23 15:28:45
Message-ID: 3A9681AD.55A3F355@soli-con.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi there

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

sum(a>b)

it just doesn't work like this

any workaround

postgres 7.0 on 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:info(at)soli-con(dot)com
mailto:olaf(dot)zanger(at)soli-con(dot)com
http://www.soli-con.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-23 15:34:42 Re: Can a function return a record set?
Previous Message Olaf Marc Zanger 2001-02-23 15:22:08 sum(bool)?