multi-word expression full-text searching

From: "Fco(dot) Mario Barcala" Rodríguez <lbarcala(at)freeresearch(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: multi-word expression full-text searching
Date: 2008-06-30 15:50:02
Message-ID: 1214841002.5802.18.camel@tambre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all:

I'm testing all full-text searching possibilities of PostgreSQL and...

Is it possible to search for a multi-word expression?

I can search one or more words:

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite');

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite & subject');

But it seems not be possible to do a query like:

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite this');

to search the documents in which occur the expression "despite this".
This last query gives the following error:

ERROR: syntax error in tsquery: "despite this"

Is it really impossible to searh a multi-word expression?

Thanks in advance,

Mario Barcala

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-06-30 16:24:24 Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks
Previous Message A B 2008-06-30 15:48:58 Re: "The tuple structure of a not-yet-assigned record is indeterminate."