On Tue, Mar 5, 2013 at 9:47 AM, Nico Williams <n...@cryptonector.com> wrote: > Well, under the hood table functions could use temp, gensym'ed virtual > tables for all I care. The point is I want table functions :)
SQLite already has table functions of sort: PRAGMAs... They have their own issues (not real tables, so cannot be used in joins, AFAIK), and of course you cannot add your own PRAGMA in client code using the SQLite3 C API. I'm hoping there's no big leap between current PRAGMAs and real table functions, with SQL grammar changes to be able to <<<select * from TABLE(my_table_func(...))>>>, and that Dr. Hipp agrees table functions would be a valuable addition of course :). --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users