Description
The datatype clause in cast exceptions are case sensitive, although they’re not case sensitive in a create table statement. For example,
select (cast id as INTEGER) from mytab;
will work, but
select (cast id as integer) from mytab;
gives a parse error.