Re: full text searching
От | Mitch Vincent |
---|---|
Тема | Re: full text searching |
Дата | |
Msg-id | 00aa01c08f90$b5ca4ad0$0200000a@windows обсуждение исходный текст |
Ответ на | full text searching (Culley Harrelson <culleyharrelson@yahoo.com>) |
Список | pgsql-general |
> 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
В списке pgsql-general по дате отправления: