Hello!

I did write yesterday message "Table functions emulation" with description of 
function for generating table with integers ranging.


create table testrange(rowid);
select intrange2table (1,10,1,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10

В сообщении от Friday 15 August 2008 02:16:56 Michael Janis написал(а):
> The approach is to construct (and index) a simple one-dimensional table
> with integers ranging from 1 to some arbitrarily large number (larger than
> the number of rows in your largest table, for example) and then use this as
> a type of "iterator" across the data.
>

...

> sqlite>create table iterator(i int);
>
> sqlite>insert into iterator values (1);
>
> sqlite>insert into iterator values (2);
>
> sqlite>insert into iterator values (3);
>
> sqlite>insert into iterator values (4);
>
> sqlite>insert into iterator values (5);
>
> sqlite>insert into iterator values (6);
>
> sqlite>insert into iterator values (7);
>
> sqlite>insert into iterator values (8);
>
> sqlite>insert into iterator values (9);
>
> sqlite>create index iter on iterator(i);



Best regards, Alexey.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to