Re: tsearch2 error msg

From: AgentM <agentm(at)themactionfaction(dot)com>
To: PostgreSQL-development hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tsearch2 error msg
Date: 2006-10-03 16:55:39
Message-ID: 551DED42-1923-452E-8DFE-742CAEC740D0@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Oct 3, 2006, at 10:49 , Oleg Bartunov wrote:

> On Tue, 3 Oct 2006, Magnus Hagander wrote:
>
>>> BTW, try
>>> # select plainto_tsquery('foo bar');
>>> plainto_tsquery
>>> -----------------
>>> 'foo' & 'bar'
>>> (1 row)
>>>
>>> It parses plain text and makes tsquery. Function exists only in 8.2
>>> - some later we add docs about changes in tsearch2.
>
> Current docs, covering 8.2 is available from http://www.sai.msu.su/
> ~megera/wiki/tsearch2slides

This is great news- previously, I was using various regexes to
sanitize input into user-accessible search fields. Would it be build
in some simple query language?

"sam AND spade"
"blue OR yellow"
"(same AND spade) OR (blue AND yellow)"

Obviously, the conjunctions would need to be defined on a per-locale
basis.

-M

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-10-03 16:57:17 Re: [HACKERS] timestamptz alias
Previous Message Jim C. Nasby 2006-10-03 16:47:16 Re: [HACKERS] timestamptz alias