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
