Re: Use contains

Hi,

if you want to use intermedia text, you have to create a primary key constraint on no first. Then you can create the index with create index imedia_1 on test1(nom) indextype is ctxsys.context;

To search the desired no you would try:

SQL> select no from test1 where contains(nom,'more') > 0;

no rows selected

surprise, surprise....

2nd test:

SQL> select no from test1 where contains(nom,'babe') > 0;

        NO

         1

Result: I think "more" has been in the stopword list, so intermedia Text didn't add it to the index - these are the little pits of intermedia Text!!

Regards

Klaus

"Robert Thibault" <rthibeau_at_videotron.ca> schrieb im Newsbeitrag news:N_275.1344$zu5.42717_at_wagner.videotron.net...
> I search how use "contains"
> for extract results.
> Ex
> create table test1
> (no number(2),
> nom varchar(255),
> prenom char(15));
> insert into test1
> values(1,'more babe','bob');
> insert into test1
> values(2,'sum tot more','you');
> create index ind_test1 on test1(nom);
>
> I wnat extract the no where the nom "contains" the word "more"
>
> thank you every body
> Cyber
>
>
Received on Fri Jun 30 2000 - 00:00:00 CEST