Re: Problem with full-text search order by with UNION
Posted by:
Rick James
Date: December 04, 2008 09:17PM
1. Don't have an answer to your question.
2. Workaround: Put the results into TEMPORARY tables, then UNION them.
3. IIRC, relevance in one table is not comparable to that in another. Hence, the final results may (or may not) be in the desired order.
Subject
Views
Written By
Posted
8498
September 30, 2008 11:17AM
Re: Problem with full-text search order by with UNION
4145
December 04, 2008 09:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.