Laurent,
take a look at contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
It does exactly what you want and more.
Oleg
On Fri, 29 Aug 2003, Laurent Patureau wrote:
>
> Hi,
>
> I'm looking for a SELECT request on PostgreSQL for a search engine.
> I'd like the reques
Hi,
I'm looking for a SELECT request on PostgreSQL for a search engine.
I'd like the request return me the pertinence (relevance) of each
result.
I've found the MySQL syntax on the web :
mysql> SELECT id, body, MATCH (title,body) AGAINST
-> ('Security implications of running MySQL as root') AS
