Re: 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:

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