Postgres Pro
Downloads
Home   >   mailing lists

Is it possible to use index on column for regexp match operator '~'? - Mailing list pgsql-performance

From Rural Hunter
Subject Is it possible to use index on column for regexp match operator '~'?
Date
Msg-id 4EE8C94B.5000607@gmail.com
Whole thread Raw
Responses Re: Is it possible to use index on column for regexp match operator '~'?
List pgsql-performance
Tree view 
for example, the where condition is: where 'aaaa' ~ col1. I created a
normal index on col1 but seems it is not used.

pgsql-performance by date:

Previous
From: Jon Nelson
Date:
Subject: Re: copy vs. C function
Next
From: voodooless
Date:
Subject: Re: Partitions and joins lead to index lookups on all partitions