Re: Full text search strategy for names - Mailing list pgsql-general

From Tom Lane
Subject Re: Full text search strategy for names
Date
Msg-id 6624.1240173527@sss.pgh.pa.us
Whole thread Raw
In response to Re: Full text search strategy for names  (Rick Schumeyer <rschumeyer@gmail.com>)
List pgsql-general
Rick Schumeyer <rschumeyer@gmail.com> writes:
> I also noticed that the directions for indexing multiple columns don't seem
> to be quite right.

> In section 12.2.2:

> UPDATE pgweb SET textsearchable_index_col =
>      to_tsvector('english', coalesce(title,'') || coalesce(body,''));

Yeah, this would be better done with a space in the middle.  I've
corrected the documentation --- thanks for the comment!

(Note that you could do it in other ways that don't require this,
ie feed the columns to to_tsvector() separately; but in the terms of
this particular example, you do want a space to avoid running words
together.)

            regards, tom lane

pgsql-general by date:

Previous
From: Henry
Date:
Subject: Re: Partitioned table and trigger/insert result horribleness
Next
From: Martijn van Oosterhout
Date:
Subject: DISTINCT ON without ORDER BY