Difference between revisions of "DB TSINDEX"

From Recital Documentation Wiki
Jump to: navigation, search
(Example)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
=DB_TSINDEX=
+
''Deprecated in Recital 10''
 
+
 
+
==Class==
+
Environment Variables / Symbols
+
 
+
  
 
==Purpose==
 
==Purpose==
Line 25: Line 20:
 
ON
 
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 Database Server, Recital Mirage Server, Recital Terminal Developer
+
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

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