Thread: Postgresql Text Search
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.
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
******************************************************************************
On Mon, 15 Sep 2008, Chris.Ellis@shropshire.gov.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@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83