[sqlite] Calling FTS tokeniser functions manually

2016-05-13 Thread Dan Kennedy
On 05/13/2016 09:19 PM, Matt Hamilton wrote: > Hi all, >Anyone know if/how you can call the FTS5 tokeniser functions manually? > e.g. I want to look something up in the fts5vocab table but can't as I need > to split/stem the initial value first before querying the table? > > To illustrate: >

[sqlite] Calling FTS tokeniser functions manually

2016-05-13 Thread Matt Hamilton
> On 13 May 2016, at 16:04, Dan Kennedy wrote: > > On 05/13/2016 09:19 PM, Matt Hamilton wrote: >> Hi all, >> Anyone know if/how you can call the FTS5 tokeniser functions manually? e.g. >> I want to look something up in the fts5vocab table but can't as I need to >> split/stem the initial valu

[sqlite] Calling FTS tokeniser functions manually

2016-05-13 Thread Matt Hamilton
Hi all, Anyone know if/how you can call the FTS5 tokeniser functions manually? e.g. I want to look something up in the fts5vocab table but can't as I need to split/stem the initial value first before querying the table? To illustrate: sqlite> CREATE VIRTUAL TABLE ft1 USING fts5(x, tokenize =