Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i Text:SCORE always return the same value...

Oracle 9i Text:SCORE always return the same value...

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Mon, 14 Oct 2002 20:50:20 +0200
Message-ID: <aof3m3$m2n1b$1@ID-114658.news.dfncis.de>


Hello all,

Why this kind of query always get the same scores?

SELECT (.7*SCORE(1) + .3*SCORE(2)), FOGVW_SEARCHCUSTOMERS.* FROM FOGVW_SEARCHCUSTOMERS
WHERE (CONTAINS(LAST_NAME, 'fuzzy(?Azua,65,100,weight)', 1) > 0 OR CONTAINS(FIRST_NAME, 'fuzzy(?Giovanni,65,100,weight)', 2) > 0 ) ORDER BY (.5*SCORE(1) + .3*SCORE(2)) DES TIA,
Best Regards,
Giovanni Received on Mon Oct 14 2002 - 13:50:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US