Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, see the
blog post
IS_INTEGER function
Returns true for numbers of scale 0 in the 32-bit range, and false for anything else
(including null and floating point numbers).
The IS_INTEGER function is a superset of the IS_SMALLINT function.
Syntax
IS_INTEGER(super_expression)
Arguments
- super_expression
-
A
SUPERexpression or column.
Return type
BOOLEAN
Examples
To check if 5 is an INTEGER using the IS_INTEGER function, use the following example.
CREATE TABLE t(s SUPER); INSERT INTO t VALUES (5); SELECT s, IS_INTEGER(s) FROM t;+---+------------+ | s | is_integer | +---+------------+ | 5 | true | +---+------------+
