Ever since I started using FTS extensively, I frequently ran into this
limitation:
** TODO: Strangely, it is not possible to associate a column specifier
** with a quoted phrase, only with a single token. Not sure if this was
** an implementation artifact or an intentional decision when fts3
2011/11/14 nobre
>
> Comment from the source:
>
> ** TODO: Strangely, it is not possible to associate a column specifier
> ** with a quoted phrase, only with a single token. Not sure if this was
> ** an implementation artifact or an intentional decision when fts3 was
> ** first implemented. W
Comment from the source:
** TODO: Strangely, it is not possible to associate a column specifier
** with a quoted phrase, only with a single token. Not sure if this was
** an implementation artifact or an intentional decision when fts3 was
** first implemented. Whichever it was, this modul
When I have a basic FTS query that needs to be restricted to a column, I
can write it in two ways:
1.) WHERE column MATCH 'apple'
2.) WHERE table MATCH 'column:apple'
But when I have a phrase query, I can only write it in one way:
1.) WHERE column MATCH '"apple juice"'
The problem is that when
4 matches
Mail list logo
