Automatic Coercion Between Integers and Strings
The DBMS Server performs automatic coercion between integer/float data types and char, varchar, nchar, or nvarchar data types. For example, an INSERT can place a quoted string value into an integer column or a database procedure can have an assignment statement that assigns a float value to a char variable—all without using explicit coercion functions such as CHAR() or INT4().