Benjamin Arai <me@xxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
