View source for DB TSINDEX

From Recital Documentation Wiki

← DB TSINDEX

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page:

''Deprecated in Recital 10'' ==Purpose== Must be set to enable Text Search Index functionality ==See Also== [[SET TSLENGTH]], [[TSPOS()]], [[TSWORD()]] ==Description== The DB_TSINDEX environment variable / symbol is used to enable Text Search Index functionality. It must be set to "ON" for Text Search Indexes to operate correctly. Text Search Indexes are created using the TSWORD() function in the key and searched using the TSPOS() function. ==Example== <code lang="recital"> ? getenv([DB_TSINDEX]) ON use example index on tsword(first_name+last_name,1) to namesearch </code> ==Products== Recital, Recital Server [[Category:Documentation]] [[Category:Configuration]] [[Category:Environment Variables|TSINDEX]] [[Category:Deprecated]]

Return to DB TSINDEX.