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