CATSEARCH Operator
With the CATSEARCH operator, you specify your query expression with the text_query argument and your optional structured criteria with the structured_query argument. The text_query argument enables you to query words and phrases. You can use logical operations, such as logical and, or, and not. This book refers to these operators as the CTXCAT grammar.
If you want to use the much richer set of operators supported by the CONTEXT grammar, you can use the query template feature with CATSEARCH.
With structured_query argument, you specify your structured criteria. You can use the following SQL operations:
-
= -
<= -
>= -
> -
< -
IN -
BETWEEN
You can also use the ORDER BY clause to order your output.
See Also: