On Tue, Apr 30, 2002 at 04:45:33PM -0700, Peter Darley wrote:
> Friends,
> I was reading through the Rules section of the online docs, and noticed the
> following note: (* is just an abbreviation for all the attribute names of a
> relation. It is expanded by the parser into the individual attributes, so
> the rule system never sees it.)
> Does this mean that count(*) may return less than the total number of
> records if all the fields in a record are NULL?
Yes, I beleive so.
> If this is true, is there a better way to get a count of records?
I think count(1) is the common suggestion.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America