Previous   Next 

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)