SYSRESULTSET

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Used to return the singleton result from any Recital expression


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

The SYSRESULTSET system table is used to return the singleton result from any Recital expression.


Column Data Type Width
<expression1> <result1 type> <result1 width>
<expression256> <result256 type> <result256 width>


An error will occur if any expression is specified that returns more than one result.


Example

select set("EXCLUSIVE") as Excl, time() as Time from sysresultset


Products

Recital, Recital Server