Re: Counting propositions

• Post for FREE via your newsreader at post.usenet.com ****

"--CELKO--" <jcelko212_at_earthlink.net> wrote in message news:18c7b3c2.0406141957.29e933ea_at_posting.google.com...
> One problem here is that COUNT(*) is CARDINALITY of the set qua set,
> while COUNT([DISTINCT] <exp>) is at the element level inside the set.
> Maybe we should have made the syntax: "CARDINALITY(<table
> expression>)" so you'd know the level that the operatgor is working
> at.

Do you think there is a need for a CARDINALITY(<table expression>) operator in addition to COUNT(DISTINCT <exp>) ?

What is the difference between COUNT(*) and COUNT(<exp>) ?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=