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

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Is it possible to use index on column for regexp match operator '~'?
Date: 2011-12-14 16:05:31
Message-ID: 4EE8C94B.5000607@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message voodooless 2011-12-14 16:06:20 Re: Partitions and joins lead to index lookups on all partitions
Previous Message Jon Nelson 2011-12-14 15:51:05 Re: copy vs. C function