count( only if true)

From: peter pilsl <pilsl(at)goldfisch(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: count( only if true)
Date: 2005-10-12 18:42:02
Message-ID: 434D58FA.2080704@goldfisch.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


the count-aggreate counts every expression that does not evaluate to null.

I would like to have a count that counts all values that are true.

Do I really need to make a count( case when expression then 't' else
null) to implement this?

thnx,
peter

--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fae +43 699 4 3574035
pilsl(at)goldfisch(dot)at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2005-10-12 19:19:09 Re: count( only if true)
Previous Message Jussi Mikkola 2005-10-12 18:19:19 Re: [GENERAL] Oracle buys Innobase