David Johnston <polobo@yahoo.com> wrote:=0A=0A> varchar(100)=0A=0A> The oth=
er option to index words via the full-text search capabilities.=0A=0AOr for=
columns this short,=A0 a similarity search on a trigram index.=0A=0Ahttp:/=
/www.postgresql.org/docs/current/interactive/pgtrgm.html=0A=0A--=0AKevin Gr=
ittner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterprise Postgre=
SQL Company