Re: Counting propositions

From: Laconic2 <>
Date: Tue, 15 Jun 2004 08:00:39 -0400
Message-ID: <>

"--CELKO--" <> wrote in message
> 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.

Speaking of that, I've seen several examples where the writer puts

SELECT COUNT(1) FROM source WHERE (predicate);

I've always wondered whether there are any consequences to that usage, other than readability? Received on Tue Jun 15 2004 - 14:00:39 CEST

Original text of this message