Re: Examples of SQL anomalies?

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.

KHD Received on Tue Jul 08 2008 - 04:50:06 CEST