Jean-Christophe Deschamps wrote: >> Why not just >> >> select some_scalar_function(i) where i between 1 and 5; > > That's because we then get > No such column: i.
Ah. You want table-valued functions, like this: http://msdn.microsoft.com/en-us/library/ms191165.aspx Those should appear where a table may - in your example, in a FROM clause. Having one in a WHERE clause makes no sense. WHERE clause never introduces a new identifier. In any case, SQLite doesn't support table-valued functions. The closest thing to it is a virtual table: http://www.sqlite.org/cvstrac/wiki?p=VirtualTables -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users