Re: Examples of SQL anomalies?

Keith H Duggar <duggar_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 Received on Tue Jul 08 2008 - 13:41:31 CEST