转换运算函数

概述

以下转换函数接受单个输入序列，并生成所需类型的输出序列。

函数	说明
seq_integer( input )	将浮点数序列元素转换为整数
seq_real( input )	将整数序列元素转换为浮点数

示例

以下是一个示例代码片段，展示了转换函数的用法：

    -- seq_integer, seq_real
            
     
    INSERT INTO SimpleSequence(testNumber,fVal1)
        VALUES(7,'{4.9,10.3,13.7}');
    INSERT INTO SimpleSequence(testNumber,iVal1)
        VALUES(8,'{3,5,7,11,13}');
     
    SELECT fVal1, seq_integer(fVal1) AS "int" FROM SimpleSequence WHERE testNumber = 7;
    SELECT iVal1, seq_real(iVal1) AS "real" FROM SimpleSequence WHERE testNumber = 8;
     
    fVal1{}
    int{}
    ------------------------------------------------------------------------------
    {4.900000, 10.300000, 13.700000}
    {4, 10, 13}
     
    iVal1{}
    real{}
    ----------------------------------------------------------------------------
    {3, 5, 7, 11, 13}
    {3.000000, 5.000000, 7.000000, 11.000000, 13.000000}