Jean-Christophe Deschamps wrote: > I'm trying to determine if a Range(from, to) function can be made as an > extension function. > > Its effect would be to expand, for instance, range(1, 5) into (1, 2, 3, > 4, 5) for use in constructs similar to > select some_scalar_function(i) where i in range(1, 5); > without having to build a table holding integers 1..5
I don't see how SQLite would accept that as a valid syntax, no matter how you define the function. However, I don't understand the point of the exercise. Why not just select some_scalar_function(i) where i between 1 and 5; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users