On Tue, Mar 5, 2013 at 2:44 AM, Dominique Devienne <ddevie...@gmail.com> wrote: > On Tue, Mar 5, 2013 at 9:24 AM, Nico Williams <n...@cryptonector.com> wrote:
> Right. Virtual Tables are very flexible, but the syntax is indeed not > practical, and it also forces you to name and "instantiate" tables, when > often you want to use table functions on the fly in a JOIN. I agree with everything you said. > VTables just isn't the right fit for table functions IMHO. My $0.02. --DD Well, under the hood table functions could use temp, gensym'ed virtual tables for all I care. The point is I want table functions :) > PS: Table functions are basically the "reverse" of aggregate functions to > me. They take scalar inputs, and generate rows, while aggregate functions > take rows and generate scalar(s).. Indeed! Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users