Writing Queries Requesting a Clustered Result Set

To obtain a clustered result set, specify “fts_cluster asc” as the sort specification in the sort_by pseudo column of the query. For example:

select t1.score, t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id
and t1.index_any = "<many> <word> software"
and t1.max_docs = 10
and t1.sort_by = "fts_cluster asc"

Include any of the following pseudo columns in your query to return additional clustering information:

See the sample script named sample_text_queries.sql in the $SYBASE/$SYBASE_FTS/sample/scripts directory for examples of SQL statements using clustering.