Installing a language dictionary (Continued)
Example showing the difference in stemming.
SELECT to_tsvector('default', 'PostgreSQL is an object-relational database management system.');
to_tsvector
-------------------------------------------------------------------------------------
'manag':8 'relat':6 'object':5 'system':9 'databas':7 'object-rel':4 'postgresql':1
(1 row)
SELECT to_tsvector('default_english', 'PostgreSQL is an object-relational database management system.');
to_tsvector
------------------------------------------------------------------------------------------------
'object':5 'system':9 'database':7 'management':8 'object-rel':4 'postgresql':1 'relational':6
(1 row)
|