Re: sql-99 array type
Date: Thu, 29 Jun 2006 07:39:33 GMT
Message-ID: <VsLog.3565$pu3.87167_at_ursa-nb00s0.nbnet.nb.ca>
Darnel Castnblast wrote:
> Are there any databases that have implemented the
> array type, found in the sql-099 spec?
>
> Doesn't this (array types in sql) mean
> relational tables could model many-to-one relations
> in a more tree-like manner, where the attachee table
> holds pointers to the attacher tables of a
> many-to-one relationship?
>
> If so, this would make automated GUI form
> generation (matching a schema) almost trivial.
And everything else almost impossible.
(I forget what product implemented it, but I recall Dennis Shasha is fond of some product that supports something called an arrable. I found the idea a flawed pollution of the logical data model created solely for performance, but you might enjoy it.) Received on Thu Jun 29 2006 - 09:39:33 CEST