X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 40DE1D1B8BD for ; Fri, 29 Aug 2003 10:41:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11359-05 for ; Fri, 29 Aug 2003 07:40:50 -0300 (ADT) Received: from smtp.noos.fr (nan-smtp-06.noos.net [212.198.2.75]) by svr1.postgresql.org (Postfix) with ESMTP id 80B5CD1B8AD for ; Fri, 29 Aug 2003 07:40:46 -0300 (ADT) Received: (qmail 37777222 invoked by uid 0); 29 Aug 2003 10:40:42 -0000 Received: from unknown (HELO IDFR4.idfr.net) ([195.132.30.222]) (envelope-sender ) by 212.198.2.75 (qmail-ldap-1.03) with SMTP for ; 29 Aug 2003 10:40:42 -0000 Message-Id: <5.0.0.25.0.20030829123618.02819278@pop.noos.fr> X-Sender: lpatureau@pop.noos.fr X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Fri, 29 Aug 2003 12:41:57 +0200 To: pgsql-sql@postgresql.org From: Laurent Patureau Subject: Select Match on PostgreSQL. Mime-Version: 1.0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_50_60, MIME_HTML_ONLY, RCVD_IN_OSIRUSOFT_COM X-Spam-Level: X-Archive-Number: 200308/355 X-Sequence-Number: 14971
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 score
-> FROM articles WHERE MATCH (title,body) AGAINST
-> ('Security implications of running MySQL as root');

But how can I do it on PostgreSQL where Match syntax is not accepted ?

Thanks to help me.

Regards.

Laurent Patureau.
Co-g=E9rant / Ing=E9nieur d'Affaire.
____________________________________
          =             &nb= sp; Laurent Patureau
            &nb= sp;            =    
S.A.R.L. ID.fr

            &nb= sp;   mailto:lpatureau@i= dfr.net

            &nb= sp;         http://www.idfr.net=

    Porter un nouveau regard =E0 votre audience :
            &nb= sp;      http://www.wysistat= .com

            &nb= sp;        Tel : 03 81 48 03 13
            &nb= sp;        Fax : 03 81 48 04 83

           16, Boulevard Winston Churchill
            &nb= sp;         25 000 Besan=E7on
___________________________________