Re: [sqlite] Implicitly creating a table containing the first N consecutive integers?

On Tue, Jun 07, 2011 at 06:12:55PM -0400, Richard Hipp scratched on the wall: > On Tue, Jun 7, 2011 at 5:44 PM, Guenther Brunthaler > wrote: > > See > http://www.sqlite.org/src/artifact/6129adfbe7c7444f2e60cc785927f3aa74e12290 > for an example implementation of a virtual

Re: [sqlite] Implicitly creating a table containing the first N consecutive integers?

On Tue, Jun 07, 2011 at 11:44:20PM +0200, Guenther Brunthaler scratched on the wall: > 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

Re: [sqlite] Implicitly creating a table containing the first N consecutive integers?

On Tue, Jun 7, 2011 at 5:44 PM, Guenther Brunthaler wrote: > 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

Re: [sqlite] Implicitly creating a table containing the first N consecutive integers?

On Jun 7, 2011, at 11:44 PM, Guenther Brunthaler wrote: > 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? The short of it: no, not out-of-the-box. ___