Re: Aggregate functions on empty sets in SQL

From: David Cressey <david_at_dcressey.com>
Date: Tue, 06 Nov 2001 19:09:45 GMT
Message-ID: <ZzWF7.68$ec1.8634_at_petpeeve.ziplink.net>

Mikito,

For better or for worse, the aggregate functions were defined to have no value when aggregating over an
empty set. Hence NULL is the right answer.

One could argue whether the definition is as useful as it might be, but that's a different story.

--
Regards,
    David Cressey
    www.dcressey.com

Received on Tue Nov 06 2001 - 20:09:45 CET

This message: [ Message body ]
Next message: Barry: "Re: data modeling"
Previous message: Remo Williams: "SQL problem enclosed. SELECTing moving window of values..."
In reply to: Mikito Harakiri: "Aggregate functions on empty sets in SQL"
Next in thread: D_at_B.A: "Re: Aggregate functions on empty sets in SQL"
Reply: Lennart Jonsson: "Re: Aggregate functions on empty sets in SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message