Postgres Pro
Downloads
Home   >   mailing lists

sum(bool)? - Mailing list pgsql-sql

From Olaf Zanger
Subject sum(bool)?
Date
Msg-id 3A9681AD.55A3F355@soli-con.com
Whole thread Raw
Responses sum(bool)?  (Daniel Wickstrom <danw@rtp.ericsson.se>)
Re: sum(bool)?  (Tod McQuillin <devin@spamcop.net>)
Re: sum(bool)?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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@soli-con.com
mailto:olaf.zanger@soli-con.com
http://www.soli-con.com

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert values
Next
From: "Josh Berkus"
Date:
Subject: Re: Can a function return a record set?