Re: Counting propositions

From: x <x-false_at_yahoo.com>
Date: Tue, 15 Jun 2004 14:19:12 +0300
Message-ID: <40ceda35$1_at_post.usenet.com>


  • 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Tue Jun 15 2004 - 13:19:12 CEST

Original text of this message