Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: full text search on only some rows in the table?

Re: full text search on only some rows in the table?

From: Pascal Damian <pascaldamian_at_icqmail.com>
Date: 8 Feb 2004 20:58:34 -0800
Message-ID: <6bd4a4d3.0402082058.79541a13@posting.google.com>


Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<9n0d20ljjebdg658ed4e7j9gbejhab6bi2_at_4ax.com>...
> Approaching it from the other direction, another possible approach could be to
> make the Text index a USER_DATASTORE index, based on a function that returns
> NULL for the docs you don't want indexed, and the actual content for those you
> do?

Yes, I think this is a nicer approach, because I don't want to ruin the design by splitting the table. Thanks for the hint.

--
Pascal
Received on Sun Feb 08 2004 - 22:58:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US