[sqlite] FTS5 query that to match all rows.

On 04/13/2016 11:24 PM, John Found wrote: > What FTS5 query should I use in order to match all rows in the table? > Can you use "SELECT * FROM fts_table;"? Dan.

[sqlite] FTS5 query that to match all rows.

On Wed, 13 Apr 2016 19:41:34 +0200 R Smith wrote: > Or did you mean you publish an interface of sorts in your application > that allows users to run their own queries, but it /has/ to be an "fts5" > query in some way, and now sometimes they want to list all rows? It is > quite baffling - but

[sqlite] FTS5 query that to match all rows.

On Wed, 13 Apr 2016 23:38:04 +0700 Dan Kennedy wrote: > On 04/13/2016 11:24 PM, John Found wrote: > > What FTS5 query should I use in order to match all rows in the table? > > > > Can you use "SELECT * FROM fts_table;"? > *I* can. But the users of the program where I use SQLite can't simply

[sqlite] FTS5 query that to match all rows.

On 2016/04/13 6:44 PM, John Found wrote: > On Wed, 13 Apr 2016 23:38:04 +0700 > Dan Kennedy wrote: > >> On 04/13/2016 11:24 PM, John Found wrote: >>> What FTS5 query should I use in order to match all rows in the table? >>> >> Can you use "SELECT * FROM fts_table;"? >> > *I* can. But the users