Difference between revisions of "DB TSINDEX"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ''Deprecated in Recital 10'' | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
==Purpose== | ==Purpose== | ||
| Line 23: | Line 18: | ||
<code lang="recital"> | <code lang="recital"> | ||
? getenv([DB_TSINDEX]) | ? getenv([DB_TSINDEX]) | ||
| − | + | ON | |
use example | use example | ||
| − | index on tsword(first_name+last_name,1) to namesearch</code> | + | index on tsword(first_name+last_name,1) to namesearch |
| + | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Configuration]] | [[Category:Configuration]] | ||
[[Category:Environment Variables|TSINDEX]] | [[Category:Environment Variables|TSINDEX]] | ||
| + | [[Category:Deprecated]] | ||
Latest revision as of 10:21, 4 March 2010
Deprecated in Recital 10
Contents
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
? getenv([DB_TSINDEX]) ON use example index on tsword(first_name+last_name,1) to namesearch
Products
Recital, Recital Server
