Re: general purpose full text indexing
От | Sean Davis |
---|---|
Тема | Re: general purpose full text indexing |
Дата | |
Msg-id | 000c01c537ee$a15f7920$5179f345@WATSON обсуждение исходный текст |
Ответ на | general purpose full text indexing (Avishai Weissberg <ovesh1@yahoo.com>) |
Список | pgsql-general |
----- Original Message ----- From: "Avishai Weissberg" <ovesh1@yahoo.com> To: <pgsql-general@postgresql.org> Sent: Monday, March 28, 2005 2:00 PM Subject: [GENERAL] general purpose full text indexing > Hello, > > I am trying to find a suitable FTI component. > > I am aware of tsearch2, but as far as I understand it doesn't really suit > my purposes. I want to be able to run a search on a huge TEXT column, > where the the column's content is made of words (each 'word' is an email > address) seperated by white-spaces and commas. The search should also > support wild-chars. Lexemes are not needed, as the 'words' are not in any > language. > > An example entry would be: > =========== > 'anbd@ijadf.com, okok@uhuh.org,plpl@erer.com, spsp@qaqa.ne.jp' > =========== > Entries run up to several thousand charaters. > > An example query would be: > =========== > WHERE column_name like '%@uhuh.org' or column_name like '%plpl@erer.com%' > =========== > > Is there a way to do this using tsearch2 without implementing a new > parser? > Is there another component of which I am not aware for full text indexing? This exact same question (searching email columns) has come up in the past couple of weeks. I tried searching the archives for the reply, but it appears that, at least for me, search.postgresql.org is down right now. In any case, if I remember correctly, the answer was to look at: http://sun.calstatela.edu/~cysun/documentation/postgres/8/contrib/README.pg_trgm Hope this helps. You should also probably try searching the archives, as I think there are answers there. Sean
В списке pgsql-general по дате отправления: