Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Intervals

Re: Intervals

From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Fri, 12 Aug 2005 19:48:12 +0200
Message-ID: <42fce0c4$0$11072$e4fe514c@news.xs4all.nl>


Kenneth Downs wrote:
> ...I now believe intervals
> should not be first class citizens.
>
> What I tried was defining a column type "rdate" which was an interval of
> dates. Declaring column "MYDATE rdate" actually generated two columns,
> MYDATE_BEG and MYDATE_END.

This effectively ends MYDATE's atomicity/scalarness. I don't get your argument. To me it looks like: I can't easily work with intervals because they are not first class citizens. What am I missing?

[snip] Received on Fri Aug 12 2005 - 12:48:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US