GT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a boolean indicating if one value is greater than another.
USAGE
GT(value, value)
Argument Name | Description |
|---|---|
| The two values to compare |
DETAILS
GT() is a function that checks if the first argument is greater than the second argument and returns 1 (true) or 0 (false).
If at least one value is a number, a numeric comparison is performed. Thus, a string value is converted into a number when paired with a numeric value.
When both values are strings, the comparison takes into account the current sort order, which might treat uppercase and lowercase letters as equivalent.
A NULL is returned if either argument is NULL.
The function call GT(x, y) behaves in exactly the same manner as the conditional expression x > y.
EXAMPLES
SELECT GT(99, 123), GT(PI(), 3);
+-------------+-------------+
| GT(99, 123) | GT(PI(), 3) |
+-------------+-------------+
| 0 | 1 |
+-------------+-------------+
-- Disable strict mode or the select might throw an error
SET sql_mode = '';
SELECT GT('99a', 99), GT('99a', '99');
+---------------+-----------------+
| GT('99a', 99) | GT('99a', '99') |
+---------------+-----------------+
| 0 | 1 |
+---------------+-----------------+