# Re: Examples of SQL anomalies?

Date: Thu, 3 Jul 2008 07:48:15 -0700 (PDT)

Message-ID: <b5d592e6-7b3a-49d2-b730-9f86ac86399e_at_a9g2000prl.googlegroups.com>

On Jul 3, 7:19 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:

*> David Cressey wrote:
**>
**> >>MIN, MAX and AVG are meaningless when applied to an empty bag, but it seems
**>
*

> Bullshit! The identity element for min is the largest representable

*> value. The identity element for max is the smallest representable element.
*

Certainly for mathematical integers, there is no largest representable element. In more practical terms, one can imagine an "arbitrary" precision integer, which starts with a 32 bit length value followed by that many 32 bit quantities of bits. Although one *could*, on attempting to evaluation MIN of an empty set/bag, return the smallest representable number, it's not clear that allocating the 16 gigabytes of RAM that are necessary to do so is a good idea.

For fixed-size integer values, there are no implementation
difficulties.

However, I'm not sure that semantically, this is entirely what we
want, even though there is the very strong argument that the
smallest int is the identity for the operation.

Marshall Received on Thu Jul 03 2008 - 16:48:15 CEST