If I understand well the plainto_tsquery behaviour, this query match with:
Despite this, the president went out.
Despite the event, this question arise.
Right, you mean phrase search. Read the thread:
http://archives.postgresql.org/pgsql-hackers/2008-05/msg0.php
Suggested patch should be
On Tue, 1 Jul 2008, [EMAIL PROTECTED] wrote:
SELECT id FROM document WHERE to_tsvector('english',text) @@
plainto_tsquery('english','despite this');
--
Teodor Sigaev
If I understand well the plainto_tsquery behaviour, this query match with:
Despite this, the president went out.
Despite the e
>
> SELECT id FROM document WHERE to_tsvector('english',text) @@
> plainto_tsquery('english','despite this');
> --
> Teodor Sigaev
If I understand well the plainto_tsquery behaviour, this query match with:
Despite this, the president went out.
Despite the event, this question arise.
i.e., if "th
SELECT id FROM document WHERE to_tsvector('english',text) @@
plainto_tsquery('english','despite this');
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
--
Sent via pgsql-general mailing lis
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
