*** 160,165 ****
--- 160,175 ----
Question: Should we allow multiple tables to be associated
to a virtual view?
+ Virtual tables and view can be used in the FROM clause of
+ a SELECT statement just like regular tables and views. But
+ in addition, virtual tables and views in the FROM clause
+ can take arguments. These arguments are passed to the
+ open-cursor method of the C-language implementation. The
+ arguments are used, for example, to specify the search string:
+
+ SELECT id FROM emailfts('subj:features virtual table')
+ ORDER BY date DESC LIMIT 30;
+
----
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|