forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Up-to-date mirror of@postgres with Travis-CI / Appveyor integration and PRs
NotificationsYou must be signed in to change notification settings
postgrespro/postgres
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
Up-to-date mirror of@postgres with Travis-CI / Appveyor integration and PRs
Resources
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published
Languages
- C83.3%
- PLpgSQL6.0%
- Perl2.3%
- C++2.2%
- TSQL1.7%
- Yacc1.4%
- Other3.1%