Re: Examples of SQL anomalies?

From: Marshall <marshall.spight_at_gmail.com>
Date: Mon, 30 Jun 2008 15:54:27 -0700 (PDT)
Message-ID: <e666b562-eddf-4647-af60-938a3222eeb1@j33g2000pri.googlegroups.com>


On Jun 30, 10:31 am, "Brian Selzer" <br..._at_selzer-software.com> wrote:
>
> Well, the OP wanted examples of SQL anomalies, and you've just confirmed a
> big one.
>
> If you have a bag that can contain peaches, but doesn't, then the answer to
> the question "How many peaches are in the bag?" is clearly zero. If you are
> asked by the accountant, "How much were we billed by AT&T this month?" but
> AT&T didn't send a bill, then the answer is clearly zero. That SQL's COUNT
> and SUM are something other than these common sense usages exemplifies their
> anomalous nature.

[I meant to say this in my other post, but]

Brian gets it exactly right here.

Marshall Received on Mon Jun 30 2008 - 17:54:27 CDT

Original text of this message