Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group