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: Select enumeration of intergers

Re: Select enumeration of intergers

From: Marshall <marshall.spight_at_gmail.com>
Date: 10 Jul 2006 07:17:05 -0700
Message-ID: <1152541025.883323.210520@35g2000cwc.googlegroups.com>


Alvin Ryder wrote:
> frebe73_at_gmail.com wrote:
> > I need to make a select statements according to this:
> >
> > select value
> > from all_integers
> > where value => 510 and value < 515
>
> Hmm, but all those approaches are hacks. Relational operators are only
> meant to work with relations. Your request is about manipulation of a
> particular type, hence it's in the domain of stored procedures (type
> operators).

Fredrik's proposed all_integers is a unary relation with a single attribute
named "value" of type int, whose elements are every possible int value. Nothing wrong from a logical standpoint of doing relational operations on those. There might be some implementation challenges, though.

Marshall Received on Mon Jul 10 2006 - 09:17:05 CDT

Original text of this message

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