Re: Select enumeration of intergers

From: Cimode <cimode_at_hotmail.com>
Date: 7 Jul 2006 02:40:24 -0700
Message-ID: <1152265224.804501.38500_at_s16g2000cws.googlegroups.com>


To my knowledge, most implementation impose disks IO for this except Oracle which does it a RAM level. Maybe PostgresSQL?

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
>
> The result should be:
> 510
> 511
> 512
> 513
> 514
>
> Any idea how to define the view "all_integers"? I prefer a solution for
> MySQL, but solution for other vendors would be appreciated too.
>
> I alread tried the solution below but the performance is too bad
>
> create view digits as
> select 0 as digit from dual
> union
> select 1 from dual
> union
> select 2 from dual
> ....
> union
> select 9 from dual
>
> create view all_integers as
> select
> d1.digit + d2.digit*10 + d3.digit*100 + .... + d10.digit*10000000000
> from digits d1, digits d2, digits d3, .... , digits d4
>
> /Fredrik
Received on Fri Jul 07 2006 - 11:40:24 CEST

Original text of this message