/* Verify installation */
/* regular numbers in strings should all succeed */
sel is_integer('8');
/* regular numbers in strings with leading spaces should all succeed */
/* If UDF coded to ignore leading whitespace */
sel is_integer(' 8');
/* regular numbers in strings with trailing spaces should all succeed */
/* If UDF coded to ignore trailing whitespace */
sel is_integer('8 ');
/* regular numbers in strings with leading and trailing spaces */
/* should all succeed */
/* If UDF coded to ignore both leading and trailing whitespace */
sel is_integer(' 8 ');
/* Anthing that is not a number will fail */
sel is_integer('abcd');
sel is_integer('a b c d ');
sel is_integer('Teradata');
sel is_integer('r6j15');
sel is_integer('1e9');
sel is_integer('175.8');
|