Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about fulltext search and to_tsvector function - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about fulltext search and to_tsvector function
Date
Msg-id 7565.1224214645@sss.pgh.pa.us
Whole thread Raw
In response to Question about fulltext search and to_tsvector function  (Mike Christensen <imaudi@comcast.net>)
Responses Re: Question about fulltext search and to_tsvector function  (Mike Christensen <imaudi@comcast.net>)
List pgsql-general
Tree view 
Mike Christensen <imaudi@comcast.net> writes:
> Okay this one's driving me crazy.
> Should there be any difference between the following queries:

> SELECT R.Title FROM Recipes R
> WHERE (to_tsvector('english', title || description) @@
> plainto_tsquery('Cake'));

> and

> SELECT R.Title FROM Recipes R
> WHERE (to_tsvector('english', description || title) @@
> plainto_tsquery('Cake'));

Maybe it would be better to do description || ' ' || title ?
I suspect that 'Cake' is getting run together with some other
word in some of your rows ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Question about NOT NULL and default values.
Next
From: "Scott Marlowe"
Date:
Subject: Re: Question about NOT NULL and default values.