4 Replies Latest reply: Jul 9, 2012 7:42 AM by Herald ten Dam RSS

    some questions about CATSEARCH

    branislav.dobrotka
      Hi a have some teoretical questions :
      I have table :
      PKS1.SYSTEM>select * from ftxt_test;

      TEXT
      ----------------------------------------------------------------------------------------------------
      BARIBAL LEISURE TRAVEL
      BARIBAL | LEISURE TRAVEL
      B*RIBAL LEISURE TRAVEL
      LEISURE BARIBAL TRAVEL

      I create CTXCAT index :
      create index idx_ftxt_test_text on ftxt_test(text) indextype is ctxsys.ctxcat

      1.
      select * from ftxt_test where catsearch(text, '"BARIBAL..;;;;!!!.LEISURE"', '') > 0;
      PKS1.SYSTEM>select * from ftxt_test where catsearch(text, '"BARIBAL..;;;;!!!.LEISURE"', '') > 0;

      TEXT
      ----------------------------------------------------------------------------------------------------
      BARIBAL LEISURE TRAVEL
      BARIBAL | LEISURE TRAVEL
      why is result two rows , I thought that result is 0 , necause "..;;;;!!!." is phrase
      2.
      PKS1.SYSTEM>select * from ftxt_test where catsearch(text, '*EISURE', '') > 0;

      no rows selected
      Is some possiblity to use sometsing like LIKE '%EISURE'