| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: MV Keys
On Mon, 6 Mar 2006 11:50:03 +0100, Jon Heggland <heggland_at_idi.ntnu.no>
wrote:
>In article <1141409876.758527.66510_at_i39g2000cwa.googlegroups.com>,
>marshall.spight_at_gmail.com says...
>> Again, my couterargument: if sets were really the right way
>> to handle ordered data, we'd represent strings as relations
>> of (foreign key, position, char).
>
>Isn't this a bit extreme? You seem to be saying here that lists is the
>right way to handle ordered data, and sets (relations) is the wrong way.
>Which means that relations almost never should be used; after all,
>almost all my relvars contain ordered data: ordered by name, or by date,
>or by importance, or ...
Do they? Or is the data in implementation-defined order and when you want it you use a view that presents the data ordered by whatever you require?
[snip]
Sincerely,
Gene Wirchenko Received on Mon Mar 06 2006 - 13:40:35 CST
![]() |
![]() |