Re: Examples of SQL anomalies?
From: Marshall <marshall.spight_at_gmail.com>
Date: Wed, 2 Jul 2008 14:10:29 -0700 (PDT)
Message-ID: <fd476a74-594c-489a-8308-069b654b30c7_at_j1g2000prb.googlegroups.com>
Date: Wed, 2 Jul 2008 14:10:29 -0700 (PDT)
Message-ID: <fd476a74-594c-489a-8308-069b654b30c7_at_j1g2000prb.googlegroups.com>
On Jul 2, 1:39 pm, -CELKO- <jcelko..._at_earthlink.net> wrote:
> >> Splitting the question up into different question (1) is the best approach here. If SQL had union types, we could do that. <<
>
> Okay,I have a union type column which alternately holds integer,
> float, strong and temporal data in each row.
> RDBMS and SQL are *very* strongly typed as part of First Normal Form.
> A scalar value has to have one and only one data type.
There are some decent type-theoretic reasons for this. Do you know what they are, I wonder?
> That is why Codd put NULLs into his type model.
Marshall Received on Wed Jul 02 2008 - 23:10:29 CEST