| description |
|---|
Determines whether an expression is a valid numeric type (DECIMAL, DOUBLE, INT, BIGINT, VARBINARY). |
- expression: Can be a general expression of any Spice-supported data type.
Examples
{% code title="ISNUMERIC example" %}
SELECT ISNUMERIC('13579')
-- True{% endcode %}
{% code title="ISNUMERIC example" %}
SELECT ISNUMERIC('Hello World!')
-- False{% endcode %}
{% code title="ISNUMERIC example" %}
SELECT ISNUMERIC(transaction_count)
FROM eth.recent_blocks
LIMIT 1
-- True{% endcode %}