Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Aggregate functions on empty sets in SQL

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@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 - 14:24:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US