Comparison Operators SQL Functions

The following comparison operators functions take two input sequences, left and right, and produce the Boolean result sequence result.

If the two input sequence arguments are of different lengths the operation will be performed on only the number of elements in the shorter of the two sequences.

seq_eq( left, right )	The element of the result sequence is true for corresponding elements that are equal in left and right sequences; otherwise false
seq_ne( left, right )	The element of the result sequence is true for corresponding elements that are not equal in left and right sequences; otherwise false
seq_gt( left, right )	The element of the result sequence is true for corresponding elements where the left element is greater than the right; otherwise false
seq_ge( left, right )	The element of the result sequence is true for corresponding elements where the left element is greater than or equal to the right; otherwise false
seq_lt( left, right )	The element of the result sequence is true for corresponding elements where the left element is less than the right; otherwise false
seq_le( left, right )	The element of the result sequence is true for corresponding elements where the left element is less than or equal to the right; otherwise false

Example

Following is an example code snippet demonstrating the comparison operator functions:

         
    -- seq_eq, seq_ne, seq_gt, seq_ge, seq_lt, seq_le
            
     
    INSERT INTO SimpleSequence(testNumber,iVal1,iVal2)
        VALUES(3,'{42,-13,27,19}','{42,-12,26,20}');
     
    SELECT iVal1,iVal2,seq_eq(iVal1,iVal2) AS "eq" FROM SimpleSequence WHERE testNumber=3;
    SELECT iVal1,iVal2,seq_ne(iVal1,iVal2) AS "ne" FROM SimpleSequence WHERE testNumber=3;
    SELECT iVal1,iVal2,seq_gt(iVal1,iVal2) AS "gt" FROM SimpleSequence WHERE testNumber=3;
    SELECT iVal1,iVal2,seq_ge(iVal1,iVal2) AS "ge" FROM SimpleSequence WHERE testNumber=3;
    SELECT iVal1,iVal2,seq_lt(iVal1,iVal2) AS "lt" FROM SimpleSequence WHERE testNumber=3;
    SELECT iVal1,iVal2,seq_le(iVal1,iVal2) AS "le" FROM SimpleSequence WHERE testNumber=3;
     
    iVal1{}
    iVal2{}
    eq{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {1, 0, 0, 0}
     
    iVal1{}
    iVal2{}
    ne{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {0, 1, 1, 1}
     
    iVal1{}
    iVal2{}
    gt{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {0, 0, 1, 0}
     
    iVal1{}
    iVal2{}
    ge{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {1, 0, 1, 0}
    iVal1{}
    iVal2{}
    lt{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {0, 1, 0, 1}
     
    iVal1{}
    iVal2{}
    le{}
    ------------------------------------------------------------
    {42, -13, 27, 19}
    {42, -12, 26, 20}
    {1, 1, 0, 1}