the above-described similarity operators, and additionally support

trigram-based index searches for <literal>LIKE</literal>, <literal>ILIKE</literal>,

<literal>~</literal>, <literal>~*</literal> and <literal>=</literal> queries.

The similarity comparisons are case-insensitive in a default build of

<filename>pg_trgm</filename>.

Inequality operators are not supported.

Note that those indexes may not be as efficient as regular B-tree indexes

for equality operator.