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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
