On Mon, Apr 7, 2014 at 5:28 PM, Dominique Devienne <ddevie...@gmail.com> wrote: > So the only piece > that's missing is an official way to use vtables "on the fly", and > pass in to its xFilter method the value from the left-correlated value > for each joined left value, so the resulting cursor can "iterate" the > right values. FWIW. --DD
Did you mean making joins a special recognizable case for virtual table implementations or something else? I also read different info about Table after your post, never used it or know about them before. But it seemed that they flourish primarily thanks to stored functions. I suppose we can't expect something like this in sqlite any time soon, nevertheless probably some small steps possible. For example, if there is already general and aggregate user functions, then some kind of enumeration one might be possible. In this case support for Table() might be added as a syntax compatibility coating or extra constraint for sqlite to determine the context of the function reference. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users