> Hi,
>
> OK full text searching. Will the full text index
> catch changes in verb tense? i.e. will a search for
> woman catch women?
>
> I'm researching before I dive in to this later in the
> week so please excuse this incompletely informed
> question: Will I need to rebuild postgresql with the
> full-text index module included? Unfortunately I'm
> away from my linux machine-- would someone be willing
> to email me the README?
Regardless of indexing, you're still searching for a specific string (if you
search using the = operator).
SELECT * from people WHERE whatever = 'woman';
-- Isn't going to catch anything but the literal string "woman".. (it's case
sensitive too, mind you)
SELECT * from people WHERE whatever LIKE 'wom%n';
-- Should check either.
A regex search is going to get more specific but when using the regex
search, you can't use indexes.
Anyone, please correct me if I'm wrong.
-Mitch