Re: Oracle text : catsearch = 0 behaviour (need to mimic contains = 0)
From: Jean-Michel S <zejeanmi_at_gmail.com>
Date: Tue, 7 Jun 2011 06:33:12 -0700 (PDT)
Message-ID: <8053c6cb-6ec1-48fc-8d62-ec305bd945bd_at_u26g2000vby.googlegroups.com>
On Jun 7, 2:39 pm, dombrooks <dombro..._at_hotmail.com> wrote:
> So, could you not rewrite using MINUS or a subquery wiith NOT IN or
> NOT EXISTS?
> e.g.
> select * from mytable where rowid not in (select rowid from mytable
> where CATSEARCH(mycolumn, 'HELLO | WORLD',NULL) > 0) ?
Date: Tue, 7 Jun 2011 06:33:12 -0700 (PDT)
Message-ID: <8053c6cb-6ec1-48fc-8d62-ec305bd945bd_at_u26g2000vby.googlegroups.com>
On Jun 7, 2:39 pm, dombrooks <dombro..._at_hotmail.com> wrote:
> So, could you not rewrite using MINUS or a subquery wiith NOT IN or
> NOT EXISTS?
> e.g.
> select * from mytable where rowid not in (select rowid from mytable
> where CATSEARCH(mycolumn, 'HELLO | WORLD',NULL) > 0) ?
Thank you.
I was looking for a simpler solution, really something like catsearch
= 0.
(because we will use catsearch in complex joins ..)
Received on Tue Jun 07 2011 - 08:33:12 CDT