Select Match on PostgreSQL.

Поиск
Список
Период
Сортировка
От Laurent Patureau
Тема Select Match on PostgreSQL.
Дата
Msg-id 5.0.0.25.0.20030829123618.02819278@pop.noos.fr
обсуждение исходный текст
Ответы Re: Select Match on PostgreSQL.
Список pgsql-sql
<br /> Hi,<br /><br /> I'm looking for a SELECT request on PostgreSQL for a search engine.<br /> I'd like the request
returnme the pertinence (relevance) of each result.<br /><br /> I've found the MySQL syntax on the web :<br />
mysql>SELECT id, body, MATCH (title,body) AGAINST<br /> -> ('Security implications of running MySQL as root') AS
score<br/> -> FROM articles WHERE MATCH (title,body) AGAINST<br /> -> ('Security implications of running MySQL as
root');<br/><br /> But how can I do it on PostgreSQL where Match syntax is not accepted ?<br /><br /> Thanks to help
me.<br/><br /> Regards.<br /><p> Laurent Patureau.<br /> Co-gérant / Ingénieur d'Affaire.<br />
____________________________________<br/><font size="2">                        Laurent Patureau<br />
                            </font><font size="1">S.A.R.L.</font><font size="2"> ID.fr<br /><br />                 <a
eudora="autourl"href="mailto:lpatureau@idfr.net">mailto:lpatureau@idfr.net</a><br /><br />                       <a
eudora="autourl"href="http://www.idfr.net/">http://www.idfr.net</a><br /><br />     Porter un nouveau regard à votre
audience:<br />                    <a eudora="autourl" href="http://www.wysistat.com/">http://www.wysistat.com</a><br
/><br/>                      Tel : 03 81 48 03 13<br />                      Fax : 03 81 48 04 83<br /><br />
          16, Boulevard Winston Churchill<br />                       25 000 Besançon<br />
___________________________________</font>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Unique constraints for a list
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Select Match on PostgreSQL.