Skip to content

Instantly share code, notes, and snippets.

@anarazel
Created September 13, 2012 15:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anarazel/3714963 to your computer and use it in GitHub Desktop.
Save anarazel/3714963 to your computer and use it in GitHub Desktop.
postgres=# CREATE TEXT SEARCH CONFIGURATION nofile ( COPY = simple);
CREATE TEXT SEARCH CONFIGURATION
Time: 210.210 ms
postgres=# ALTER TEXT SEARCH CONFIGURATION nofile DROP MAPPING FOR file;
ALTER TEXT SEARCH CONFIGURATION
Time: 2.649 ms
postgres=# SELECT * FROM ts_debug('simple', 'term1/term2');
alias | description | token | dictionaries | dictionary | lexemes
-------+-------------------+-------------+--------------+------------+---------------
file | File or path name | term1/term2 | {simple} | simple | {term1/term2}
(1 row)
Time: 5.128 ms
postgres=# SELECT * FROM ts_debug('nofile', 'term1/term2');
alias | description | token | dictionaries | dictionary | lexemes
-------+-------------------+-------------+--------------+------------+---------
file | File or path name | term1/term2 | {} | |
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment