RE: Oracle Context index returning inconsistent results
From: Robert Buda <rjbuda_at_budaconsulting.com>
Date: Mon, 26 Jan 2009 14:24:55 -0500
Message-ID: <006701c97feb$c4f76700$1500a8c0_at_BudaConsulting.local>
>A-ha! An even better explanation is the special ":" Result-set operator in
> a ConText query:
Date: Mon, 26 Jan 2009 14:24:55 -0500
Message-ID: <006701c97feb$c4f76700$1500a8c0_at_BudaConsulting.local>
>A-ha! An even better explanation is the special ":" Result-set operator in
> a ConText query:
>http://download.oracle.com/docs/cd/A57673_01/DOC/server/doc/CO20APP/ch03.ht
>m#2189
>(look for "MAX" in that page) You'll need to escape the colon, as it has
>special meaning in ConText.
Thanks for that tip but unfortunately, escaping the colon makes no difference. I did not think the colon was the problem anyway because both strings have one.
> Is there a difference in the SCORE returned in your tests?
>
>
In call cases that I listed where the query works for the value '05:1254C',
the score is 16.
When I query against the other value (which works all the time) the score is 13.
Bob
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 26 2009 - 13:24:55 CST