- Notifications
You must be signed in to change notification settings - Fork28
postgrespro/postgres_cluster
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Thepg_tsparser module is the modified default text search parser fromPostgreSQL 9.6.The difference betweentsparser anddefault parsers is thattsparsergives also unbroken words by underscore character.
This module available under the same license asPostgreSQL.
Typical installation procedure may look like this:
$ cd pg_tsparser$ sudo make USE_PGXS=1 install$ make USE_PGXS=1 installcheck$ psql DB -c "CREATE EXTENSION pg_tsparser;"
After this you can create your own text search configuration:
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;
Example of difference betweentsparser anddefault:
SELECT to_tsvector('english_ts','pg_trgm'); to_tsvector-----------------------------'pg':2'pg_trgm':1'trgm':3(1 row)SELECT to_tsvector('english','pg_trgm'); to_tsvector-----------------'pg':1'trgm':2(1 row)
About
Various experiments with PostgreSQL clustering
Resources
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
No releases published
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.