Re: Aggregate functions on empty sets in SQL
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: Wed, 07 Nov 2001 20:24:36 GMT
Message-ID: <8MgG7.16508$xS6.26071_at_www.newsranger.com>
Date: Wed, 07 Nov 2001 20:24:36 GMT
Message-ID: <8MgG7.16508$xS6.26071_at_www.newsranger.com>
In article <ZzWF7.68$ec1.8634_at_petpeeve.ziplink.net>, David Cressey says...
>
>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.
>
..with the exception of count. Wouldnt it be boring to live in a world without exceptions :-)
/Lennart Received on Wed Nov 07 2001 - 21:24:36 CET