Re: Postgresql Text Search

On Mon, 15 Sep 2008, Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk wrote:

> Hi
>
> I've been using postgresql V8.3 to build a search engine for our intranet
> site.
> This has worked very well so far proving to be quick and relevant.
>
> However I've been wondering if postgresql's full text search supports
> literal matches. IE, matching an exact phrase in a document.
> I cannot find anything pertaining to literal matches in the manual.
>
> Does anyone know whether literal matches are support or any work around
> method for this.

Chris, this is in our TODO. I'll give a short talk about progress in
phrase search in Pgday. In brief, we got algebra for text queries, which
was a stumbling block for years.

>
> Obviously I could fall back onto a 'like' condition but would prefer not
> to.
>
> Chris Ellis
>
>
> ******************************************************************************
> If you are not the intended recipient of this email please do not send it on
> to others, open any attachments or file the email locally.
> Please inform the sender of the error and then delete the original email.
> For more information, please refer to http://www.shropshire.gov.uk/privacy.nsf
> ******************************************************************************
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83