This discussion is archived
4 Replies Latest reply: Jul 9, 2012 5:42 AM by Herald ten Dam RSS

some questions about CATSEARCH

branislav.dobrotka Newbie
Currently Being Moderated
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'

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points