Postgres Pro
Downloads
Home   >   mailing lists

Re: count( only if true) - Mailing list pgsql-general

From A. Kretschmer
Subject Re: count( only if true)
Date
Msg-id 20051012192024.GA6967@webserv.wug-glas.de
Whole thread Raw
In response to count( only if true)  (peter pilsl <pilsl@goldfisch.at>)
List pgsql-general
Tree view 
am  12.10.2005, um 20:42:02 +0200 mailte peter pilsl folgendes:
>
> 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?

count(*) from foo where bar = '...';

Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: peter pilsl
Date:
Subject: count( only if true)
Next
From: Martín Marqués
Date:
Subject: Re: count( only if true)