[sqlite] Re(3): Implicitly creating a table containing the first N consecutive integers?
On 2011-06-08 00:12, Richard Hipp wrote: > See > http://www.sqlite.org/src/artifact/6129adfbe7c7444f2e60cc785927f3aa74e12290for >> ** Example: >> ** >> ** CREATE VIRTUAL TABLE nums USING wholenumber; >> ** SELECT value FROM nums WHERE value<10; >> ** >> ** Results in: >> ** >> ** 1 2 3 4 5 6 7 8 9 Thanks a lot! This is exactly what I have been looking for. Keep up the good work, Guenther ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Re(2): Implicitly creating a table containing the first N consecutive integers?
On 2011-06-07 23:52, Petite Abeille wrote: > The short of it: no, not out-of-the-box. Thanks for the quick reply. I guess a loadable extension needs to be used for this purpose then. Is there any such extension already known to be available? I would like to avoid reinventing the wheel. I could not find such an extension yet, but perhaps my Google query was missing the correct search terms. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Implicitly creating a table containing the first N consecutive integers?
Hi all, I frequently need a table in my queries for several kinds of JOIN operations which contains just the integers from 1 to N in its rows. I. e. SELECT n FROM int_seq where n <= 5; 1 2 3 4 5 However, I would like to achieve the same effect without actually creating such a table "int_seq". It it possible in SQLite to create such a table implicitly "on the fly" using some sort of recursive view/query or built-in special function? Regards, Guenther ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users