Re: InterMedia 'NEAR' operator

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 21 Feb 2000 12:10:40 GMT
Message-ID: <38b12a0c.2439487@newshost.us.oracle.com>

In interMedia Text, the NEAR operator uses the word proximity information calculated at the time of indexing.

Per the documentation, the NEAR operator is used "to return a score based on the proximity of two or more query terms." In this case, query terms means words and not phrases.

http://technet.oracle.com/doc/inter.815/a67843/cqoper.htm#27445

Hope this helps.

On Mon, 21 Feb 2000 15:49:52 +0800, "Eugene Ng" <eugeneng_at_asiansources.com> wrote:

>Hi all,
>
>I've encountered an abnormal behaviour using NEAR (;) in
>Intermedia....here's the problem....
>
>SELECT score(1), adv_prod_id, prod_name, prod_description from adv_products
>where (contains (prod_description, '$SYN(Mobile Phone,mythes);$SYN(Battery
>Charger,mythes)',1) > 1) order by score(1) desc
>
>Apparently this query will return an error, but ....
>
>SELECT score(1), adv_prod_id, prod_name, prod_description from adv_products
>where (contains (prod_description, '$SYN(Mobile,mythes);$SYN(Phone Battery
>Charger,mythes)',1) > 1) order by score(1) desc
>
>This appears to work properly.
>IMHO, it seems like the first term cannot be a phrase.......
>
>Anyone out there can help???
>
>
>

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Feb 21 2000 - 06:10:40 CST