Re: BUG #3767: tsearch2 index creation fatal crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3767: tsearch2 index creation fatal crash
Date
Msg-id 23539.1195620792@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3767: tsearch2 index creation fatal crash  ("Thomas H." <me@alternize.com>)
Responses Re: BUG #3767: tsearch2 index creation fatal crash  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
"Thomas H." <me@alternize.com> writes:
> i saw my mistake. i misinterpreted the examples to show the possibility
> to convert *any* text by using casting to tsvector as an alternative to
> using to_tsvector :)

Yeah, the examples in section 12.1.2 are not actually good practice:
both sides of the match should usually get normalized before comparison,
and these examples don't do that.

I'm not sure that putting in to_tsvector calls there would be an
improvement, though, since at that point we haven't introduced
to_tsvector.

Thoughts anyone?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: Re: BUG #3767: tsearch2 index creation fatal crash
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #3767: tsearch2 index creation fatal crash