Re: full text index / search - Mailing list pgsql-general

From Albe Laurenz
Subject Re: full text index / search
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20808CB96@exadv11.host.magwien.gv.at
Whole thread Raw
In response to full text index / search  (Philipp Kraus <philipp.kraus@flashpixx.de>)
Responses Re: full text index / search  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Léa Massiot
Date:
Subject: Re: Starting a cluster as a service
Next
From: "Tomas Vondra"
Date:
Subject: Re: full text index / search