Tomáš Vondra <tv@fuzzy.cz> writes:
> craig.macdonald@glasgow.ac.uknapsal/a:
>> The documentation at
>> http://www.postgresql.org/docs/9.2/static/textsearch-indexes.html
>> is incorrect in the syntax of CREATE INDEX for GIN and GIST. According to
>> http://www.postgresql.org/docs/9.2/static/pgtrgm.html the keyword
>> gist_trgm_ops is also necessary:
> No it's not. The documentation about full-text clearly states that the column needs to be either tsvector or tsquery,
butyou're clearly using text.
Yeah, Tomas is right: section 12.9 is discussing the core full-text-search
datatypes, which have nothing much to do with contrib/pg_trgm's
facilities.
regards, tom lane