You know that you can use the hidden columns by name in the WHERE cause correct, and do not have to use function parameters?
So the ext/misc/series.c in the repository defines a virtual table generate_series which effectively returns each "value" generated by the statement: for (value=start; value+=step; value<=stop) generate_the_value(value); You can use it as either select value from generate_series(1,100,2); the hidden columns are start, stop, step. Equivalently you can do select value from generate_series where start=1 and stop=100 and step=2; --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Brandon Kyle Schmoll >Sent: Friday, 22 June, 2018 12:30 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Question about hidden columns > >Hello All, > I am relatively new to sqlite and I have a question about using >input parameters to constrain hidden columns in a query, described in >section 2.1.2 here: > >https://www.sqlite.org/vtab.html#table_valued_functions ><https://www.sqlite.org/vtab.html#table_valued_functions> > >The documentation states that one can specify the constraint >parameters as in a function call where the first input to the >function will constrain the first hidden column, the second input >will constrain the second hidden column, and so forth. In other >words, this method emulates a function call using positional >arguments. However, it would be useful to use keyword arguments in >case you want to constrain some, but not all, of the hidden columns. >Is this possible? > >Thanks, >Brandon >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
