Error creating GIN type index

0

When trying to create an index of type GIN in a table I came across the following error:

CREATE INDEX idx_descricao on produtos USING gin (descricao gin_trgm_ops);
ERRO:  classe de operadores "gin_trgm_ops" não existe para método de acesso "gin"

By all means the syntax is correct and the column used for this type of index is text

PS: Postgres 9.6

    
asked by anonymous 20.11.2018 / 13:42

0 answers