Re: full text index / search

On 18 Červen 2012, 11:04, Albe Laurenz wrote:
> Philipp Kraus wrote:
>> I have created a table with a text field under PG 9.1, that should
> store source codes. I would like to
>> search in this text field with regular expressions. I think I need a
> full-text-index, do I?
>> How can I create this index, do I need some additional extensions? The
> PG server runs under OSX
>> (installed on the DMG package).
>
> A full text index won't help you with regular expressions.
> It will only help with full text search using the match operator @@.

Also, it's possible to create regular index with custom operator class for
pattern matching queries. See this

http://www.postgresql.org/docs/9.1/interactive/indexes-opclass.html

Not a full-text index, though ...

T.