full text index / search

I am not an expert on FTS, but I have been reading and experimenting. Further, I don't know what you are really attempting. With those warnings behind us, I think a GIN or GiST index are helpful in full text searches.

You may find this useful:
Understanding Full Text Search
http://linuxgazette.net/164/sephton.html

I suggest that you review the Postgres Documentation for FTS:
http://www.postgresql.org/docs/9.1/interactive/textsearch.html

One option you may find interesting is the pg_trgm module:
http://www.postgresql.org/docs/9.1/static/pgtrgm.html

hth,

- Mark Phillips

On Jun 15, 2012, at 8:18 AM, Philipp Kraus 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 @@.

Yours,
Laurenz Albe

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.