Re: [sqlite] Question about hidden columns

[Keith Medcalf]

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

[sqlite] Question about hidden columns

[Brandon Kyle Schmoll]

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 


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