Weird problem concerning tsearch functions built into postgres 8.3, assistance requested

Поиск
Список
Период
Сортировка
От Andrew Edson
Тема Weird problem concerning tsearch functions built into postgres 8.3, assistance requested
Дата
Msg-id 90172.97137.qm@web34205.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Weird problem concerning tsearch functions built into postgres 8.3, assistance requested
Список pgsql-general
Дерево обсуждения
I've been tasked with maintaining a set of postgres databases created by my predecessor in this position.  The original databases several years back were version 8.1.3, and used the tsearch2 functions to enable some client-program searches.

We've recently begun preparing to shift to 8.3 (I believe the current starter box we're putting together for cloning is running 8.3.1), and I've been having a bit of trouble with the built-in searching.  I think I've got it mostly fixed after following a few leads online, but I've run across one last little bit of problem that I can't figure out how to get around, and that doesn't make much sense to me.  Admittedly, I don't know very much about tsearch.

One of the tables we're using in the 8.1.3 setups currently running includes phone numbers as a searchable field (fti_phone), with the results of a select on the field generally looking like this: 'MMM':2 'NNNN':3 'MMM-NNNN':1.  MMM is the first three digits, NNNN is the fourth-seventh.

The weird part is this: On the old systems running 8.1.3, I can look up a record by
fti_phone using any of the three above items; first three, last four, or entire number including dash.  On the new system running 8.3.1, I can do a lookup by the first three or the last four and get the results I'm after, but any attempt to do a lookup by the entire MMM-NNNN version returns no records.

I saw nothing concerning this while I was looking for information on how to get the search functions properly working in postgres 8.3.1, nor have I specifically seen anything since running across that problem.  The latter, however, may simply be because I don't know how to properly phrase my searches.

Does anyone have any information they would be willing to share regarding this issue, or a link to a website which discusses it?  I would greatly appreciate any advice I may be given.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Thom Brown"
Дата:
Сообщение: Re: Can't restart Postgres
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?