Rick Schumeyer <rschumeyer@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
