Re: Iterating thru FullText Index

2004-03-05 Thread Sergei Golubchik
Hi! On Mar 05, Todd Burke wrote: > Is there any way to iterate thru the keys in a fulltext index? This issue > does not come up for other indexes since ORDER BY can achieve this: > > For example if table t is indexed on part_id > > SELECT DISTINCT part_id FROM t ORDER by part_id; > > will re

Iterating thru FullText Index

2004-03-05 Thread Todd Burke
Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return all keys in index order Is there a way to do