Difference between revisions of "TSPOS()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
=TSPOS()=
 
 
 
==Class==
 
Text Searching
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to search a Text Search Index for one or more words
 
Function to search a Text Search Index for one or more words
Line 44: Line 37:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:40, 8 December 2009

Purpose

Function to search a Text Search Index for one or more words


Syntax

TSPOS(<expC>,<expN>)


See Also

INDEX, KEY(), LOWER(), NDX(), TSWORD(), UPPER(), SET INDEX, SET ORDER, SET TSLENGTH, DB_TSINDEX


Description

The TSPOS() function is used to search the currently active Text Search Index. If the search is successful, the record pointer is positioned to the matching record and the record number is returned. If no matching record is found, the TSPOS() function returns -1.

The <expC> is the word list for which to search. Words should be space-separated. The <expN> is the occurrence number for which to search. If <expN> is 0, the index is searched for the first match to a new search or the next match based on a previous search.

The UPPER() or LOWER() functions can be used when creating indexes and when conducting index searches to make them case-insensitive.

The DB_TSINDEX environment variable / symbol must be set to "ON" when building or using Text Search Indexes.


Example

use example
index on tsword(first_name+last_name,1) to namesearch
? tspos("John",0)
        42
? tspos("John",0)
        43
? tspos("John",0)
        -1
? tspos("John",1)
        42


Products

Recital, Recital Server