Post reply

NEAR operator in full-text querys

  • May 11, 2005 at 3:28 pm

    #92998

    Hello,

    Does anyone know how to control the proximit term (NEAR) in full-text querys, to specify the maximum number of words between two terms in a NEAR operator in a CONTAINS clause.

    For example, I would like to query Dog and Cat , where Dog is within 6 words of Cat.

    In Oracle, we can a query something like it:

       'near((dog,cat),6)'

    I tried to use CONTAINSTABLE and RANK, but I don't  find any documentation than explains witch value I should query RANK to retrive only what I want.

  • May 12, 2005 at 4:53 am

    #558319

    it can't be done. In sql 7, 2000, and 2005 near is defined as words withing 1362 (IIRC) words. Any more distance and this row won't be returned in your contains or freetext query. With freetext ranking is 0 with a word seperation of more than 50 words.

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply