SQL Sequence Grand Aggregate Empty Function

The seq_empty() function returns a Boolean value indicating whether the specified sequence has values or not.

Following is an example script demonstrating the seq_empty() function:

 
 
    INSERT INTO SimpleSequence(testNumber,fVal1)
    VALUES(5,'{1.1,1.1,2.2,3.3}');
     
    SELECT seq_empty(iVal1) AS "iVal1 empty?", seq_empty(fVal1) AS "fVal1 empty?"
    FROM SimpleSequence WHERE testNumber = 5;
     
    iVal1 empty?  fVal1 empty?
    -----------------------------------------------------------------
    true          false
     

Sample script

A sample script to demonstrate this select statement using xSQL can be run from the samples/xsql/scripts/financial directory with the following command:

     
    f 1