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.
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;
The difference betweentsparser anddefault parsers is thattsparsergives also unbroken words by underscore character.
For example:
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%