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 === ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
