Re: [sqlite] sqlite/fts3 feature request: select snippet() from fts3 where docid=1

2010-11-06 Thread Richard Hipp
On Sat, Nov 6, 2010 at 7:45 AM, Simon Hefti wrote: > Hello > > Do I understand correctly that fts3 snippet function does only work > with match queries like > select snippet(text) from text where text match 'foo' > > I would be interested to have: > select snippet(text)

[sqlite] sqlite/fts3 feature request: select snippet() from fts3 where docid=1

2010-11-06 Thread Simon Hefti
Hello Do I understand correctly that fts3 snippet function does only work with match queries like select snippet(text) from text where text match 'foo' I would be interested to have: select snippet(text) from text where docid=1 In sqlite 3.7.2 this statement is valid but returns an empty