On 23 Duben 2012, 13:31, AI Rumman wrote: > What is the different between pg_trgm search and FULL Text search? > Anyone has idea on these, please let me know. pg_trgm performs "trigram matching" i.e. determines similarity of strings based on trigrams (three-character strings). It has no notion of a language, does not attempt to split the text into tokens / transform the words to basic forms etc. It merely splits the string into three-character pieces and stores this info. tsearch2 (a fulltext search) works with dictionaries for each language, turns the words into basic forms, allows you to define synonyms and much more. It has much more insight into the language structure etc. It allows you to build complex queries (AND, OR, NOT, ...) etc. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
