Re: Examples of SQL anomalies?

On Jul 8, 7:41 am, goanna <spamt..._at_crayne.org> wrote:
> Keith H Duggar <dug..._at_alum.mit.edu> writes:
>
> > CELKO wrote :
> > > Marshall wrote :
> > > > False! It's not from nothing, and it's not simply a convention.
> > > > It's the identity of the operator being aggregated. <<
>
> > > Yes, zero is the additive identity.  But this is a convention used to
> > > get rid of the empty set problem and preserve easy computations.
> > Yes, sum[{}] = 1 eliminates problems and makes computation easier.
> > It's a shame that SQL offers neither of those benefits.
>
> I guess you mean sum[{}] = 0

Yes. Thank you. Received on Thu Jul 10 2008 - 04:21:43 CEST