Re: Examples of SQL anomalies?

From: Cimode <>
Date: Sun, 6 Jul 2008 09:29:32 -0700 (PDT)
Message-ID: <>

On 2 juil, 16:56, paul c <toledoby..._at_ac.ooyah> wrote:
> -CELKO- wrote:
> >>> Once again you are introducing confusion, in this case muddying the waters with unstated design questions, confusing a system that is designed to anticipate suppliers and bills with one that isn't. <<
> > Do you really find that a credit balance is not a common business
> > practice? What I am pointing out is that a zero is a value on a scale
> > and a NULL or other missing value indicators is not. Would you like
> > to go into Codd's A and I markers?
> > Instead of rudely ranting about illiteracy (while misspelling
> > "tomorrow"), show us how to indicate when a $0.00 payment is a credit
> > balance on an actual billing or a lack of a payment on a non-existent
> > billing. The only thing that comes to mind is a flag of some kind
> > which splits the single scalar value over two or more columns in
> > violation of 1NF and leads to user-defined behaviors rather than
> > guaranteed consistent behaviors.
I strongly doubt you will get a response on this. Received on Sun Jul 06 2008 - 18:29:32 CEST

Original text of this message