Re: Logical equivalence of simple and complex types under the relational model?

"Rene de Visser" <Rene_de_Visser_at_hotmail.com> wrote:

[snip]

>Simple in the sense of RM means that the value is atomic with respect to RM.
>i.e. there are no operations within RM that can access parts of the value.
>e.g. the number 2 is atomic in RM if there are no operations that let you
>look into the structure of a '2'.
>
>All other types are complex.

     If the DBMS has a function that returns the integer part of a float, this means that float is a complex type?

>These things are quite well covered in Codds paper "Extending the database
>relational model to capture more meaning "

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.