The etx_ReturnType data type
The data type etx_ReturnType is a named row type defined by the module
as follows:
CREATE ROW TYPE etx_ReturnType
(
score REAL,
hilite_info etx_InternalHilite
);
The etx_ReturnType data type is the data type of the optional statement
local variable (SLV) of the etx_contains() operator.
Use the SLV in a SELECT statement to obtain scoring information about
the returned document or to pass internal highlighting information
to the etx_GetHilite() routine. The following example
shows a typical use of SLVs:
SELECT rc1.score, title FROM reports
WHERE etx_contains (abstract,
Row('video'), rc1 # etx_ReturnType)
AND doc_no > 1005
ORDER BY 1;
In the example, rc1 is the SLV, and its score field is used by the SELECT statement to order the returned rows by their document score.
The etx_ReturnType row type consists of two fields: score and hilite_info.