Introduction

SELECT to_tsvector('english','pg_trgm')as def_parser,       to_tsvector('english_ts','pg_trgm')as new_parser;   def_parser    |         new_parser-----------------+-----------------------------'pg':1'trgm':2 |'pg':2'pg_trgm':1'trgm':3(1 row)SELECT to_tsvector('english','123-abc')as def_parser,       to_tsvector('english_ts','123-abc')as new_parser;   def_parser    |         new_parser-----------------+-----------------------------'123':1'abc':2 |'123':2'123-abc':1'abc':3(1 row)SELECT to_tsvector('english','rel-3.2-A')as def_parser,       to_tsvector('english_ts','rel-3.2-A')as new_parser;    def_parser    |          new_parser------------------+-------------------------------'-3.2':2'rel':1 |'3.2':3'rel':2'rel-3.2-a':1(1 row)

License

Installation

$ cd pg_tsparser$ sudo make USE_PGXS=1 install$ make USE_PGXS=1 installcheck$ psql DB -c "CREATE EXTENSION pg_tsparser;"

CREATETEXT SEARCH CONFIGURATION english_ts (    PARSER= tsparser);COMMENTONTEXT SEARCH CONFIGURATION english_ts IS'text search configuration for english language';ALTERTEXT SEARCH CONFIGURATION english_ts    ADD MAPPING FOR email, file, float, host, hword_numpart,int,    numhword, numword, sfloat, uint, url, url_path, version    WITH simple;ALTERTEXT SEARCH CONFIGURATION english_ts    ADD MAPPING FOR asciiword, asciihword, hword_asciipart,    word, hword, hword_part    WITH english_stem;