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 @@.
Yours,
Laurenz Albe