[PERFORM] Is it possible to use index on column for regexp match operator '~'?

[Rural Hunter]

for example, the where condition is: where 'aaaa' ~ col1. I created a 
normal index on col1 but seems it is not used.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance