Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: interMedia
Hello!
You are mistaken that simple translate the blanks into 'AND' will be good
decision.
Lexical analyzer should take care about quotes, brackets and a lot of reserved
words (e.g. two running AND's are fault)
Small example:
aaa bbb ccc "eee fff" = = AND bbb AND ccc AND "eee fff" but
aaa bbb ccc "eee fff" != aaa AND bbb AND ccc AND "eee AND fff"
Rgds, Vadim Grepan
Barbara Kennedy wrote:
> There is a difference between
> "xxx yyy zzz"
> and
> "xxx AND yyy AND zzz"
> The first means the phrase "xxx yyy zzz" and the second means search for
> text that contains all those words. So if you want the phrase to mean and
> then yes you have to parse it out and insert the ands or &'s. I think you
> can use the translate function or replace function to replace a blank with
> and or use substr to get the consecutive words and add the ands.
> Jim
> "Vadim Grepan" <kezal_at_mail.ru> wrote in message
> news:3A235A9A.F35039F2_at_mail.ru...
> > Hello!
> >
> > I'd like to do interMedia-search with AND-clause by default. In other
> > words If I write
> > "xxx yyy zzz" the search must be "xxx AND yyy AND zzz". Unfortunatly I
> > didn't find such feature in the interMedia. Should I write my own
> > lexical analyzer?
> >
> > Rgds, Vadim Grepan
> > ------------------------------
> > Moscow, Russia
> >
> >
> >
> >
Received on Wed Nov 29 2000 - 03:38:30 CST
![]() |
![]() |