Regex query not using index

Поиск
Список
Период
Сортировка
От Postgres User
Тема Regex query not using index
Дата
Msg-id b88c3460802191932i2798352cra622e33a43af729d@mail.gmail.com
обсуждение исходный текст
Ответы Re: Regex query not using index
Список pgsql-general
I'm running a simple query on 8.2.  With this syntax, Explain indicate
that the index is scanned:
select * from eod where name = 'AA'

However, when I change the query to use simple regex:
select * from eod where name ~ 'AA'

now Explain indicates a seq scan:
Index Scan using equity_eod_symbol_idx on equity_eod  (cost=0.00..8.27
rows=1 width=149)
Index Cond: ((symbol)::text = 'AA'::text)

Is there any way to 'encourage' Postgres to hit the index when using
regex?  Do I need to create a functional index or something?
Without the index in play, I really can't use regex on any of my larger tables.

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: ERROR: relation with OID 1322527 does not exist
Следующее
От: hewei
Дата:
Сообщение: How to make update rapidly?