Benjamin Arai <me@benjaminarai.com> writes:
> The tsearch2 webpage says to do something like
> SELECT intindex, strTopic FROM tblmessages
> WHERE idxfti @@ to_tsquery('default', 'gettysburg &
> address')
> AND strMessage ~* '.*men are created equal.*';
> intindex | strtopic
> ----------+------------------------------
> 6 | Gettysburg address quotation
> (1 row)
Right.
> Which would mean I would have to create index on strMessage. Right?
Wrong. A btree index on strMessage is utterly worthless for checking
that pattern match, and even if it did work, there's no point in using
a second index to check it rather than fetching the heap entry.
regards, tom lane