Thread: Full text search

Full text search

From
Mladen Gogala
Date:
Where can I find the list of separator characters for the configuration named "english"? In other words, I need the list of characters which delimit words.
-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com 

Re: Full text search

From
Tom Lane
Date:
Mladen Gogala <mladen.gogala@vmsinfo.com> writes:
> Where can I find the list of separator characters for the configuration
> named "english"? In other words, I need the list of characters which
> delimit words.

The default parser is documented here:
http://www.postgresql.org/docs/8.4/static/textsearch-parsers.html

Anything that isn't a letter, a digit, or allowed by one of the
special cases mentioned there will be treated as a separator.

Also, a bit of experimentation with ts_debug() should clear up any
details you find unclear.

            regards, tom lane