DuroDBMS API  1.7
Built-in comparison operators

OPERATOR =

OPERATOR = (ANY, ANY) RETURNS boolean;

The equality operator. Defined for every type. The arguments must be of the same type.

Returns

TRUE if the two arguments are equal, FALSE otherwise.


OPERATOR <>

OPERATOR <> (ANY, ANY) RETURNS boolean;

Description

The inequality operator. Defined for every type. The arguments must be of the same type.

Return value

TRUE if the two arguments are not equal, FALSE otherwise.


OPERATOR <

OPERATOR < (integer, integer) RETURNS boolean;

OPERATOR < (float, float) RETURNS boolean;

OPERATOR < (string, string) RETURNS boolean;

Description

The lower-than operator.

Return value

TRUE if the first argument is lower than the first. If the operands are strings, the strings will be compared using strcoll().


OPERATOR <=

OPERATOR <= (integer, integer) RETURNS boolean;

OPERATOR <= (float, float) RETURNS boolean;

OPERATOR <= (string, string) RETURNS boolean;

Description

The lower-than-or-equal operator.

Return value

TRUE if the first argument is lower than or equal to the second. If the operands are strings, the strings will be compared using strcoll().


OPERATOR >

OPERATOR > (integer, integer) RETURNS boolean;

OPERATOR > (float, float) RETURNS boolean;

OPERATOR > (string, string) RETURNS boolean;

Description

The greater-than operator.

Return value

TRUE if the first argument is greater than the first. If the operands are strings, the strings will be compared using strcoll().


OPERATOR >=

OPERATOR >= (integer, integer) RETURNS boolean;

OPERATOR >= (float, float) RETURNS boolean;

OPERATOR >= (string, string) RETURNS boolean;

Description

The greater-than-or-equal operator.

Return value

TRUE if the first argument is greater than or equal to the second. If the operands are strings, the strings will be compared using strcoll().