On 8/18/08, Dennis Cote <[EMAIL PROTECTED]> wrote:
> P Kishor wrote:
>
> >
> > I would like to generate Snippets from MATCHes in two columns,
> > however, I get the following error: "unable to use function MATCH in
> > the requested context" with the following query --
> >
> > SELECT poem_id,
>
> I would like to generate Snippets from MATCHes in two
> columns, however, I get the following error: "unable to use
> function MATCH in the requested context" with the following query --
>
> SELECT poem_id, context
> FROM poems a JOIN (
> SELECT
> rowid,
>
P Kishor wrote:
>
> I would like to generate Snippets from MATCHes in two columns,
> however, I get the following error: "unable to use function MATCH in
> the requested context" with the following query --
>
> SELECT poem_id, context
> FROM poems a JOIN (
> SELECT
> rowid,
>
On Fri, Aug 15, 2008 at 9:13 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote:
>> I would like to generate Snippets from MATCHes in two columns,
>> however, I get the following error: "unable to use function MATCH in
>> the requested context" with the following query --
>
> I think you ran into the
On Fri, Aug 15, 2008 at 9:13 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote:
>> I would like to generate Snippets from MATCHes in two columns,
>> however, I get the following error: "unable to use function MATCH in
>> the requested context" with the following query --
>
> I think you ran into the
> I would like to generate Snippets from MATCHes in two columns,
> however, I get the following error: "unable to use function MATCH in
> the requested context" with the following query --
I think you ran into the same problem as I did:
I have the following tables
CREATE TABLE poems (poem_id, poem, history);
CREATE VIRTUAL TABLE fts_poems USING fts3 (poem, history);
INSERT INTO fts_poems (rowid, poem, history)
SELECT poem_id, poem, history FROM poems;
The following works --
SELECT poem_id, context
FROM poems a JOIN (
7 matches
Mail list logo