|
|
|
|
|
|
Vertica supports a subset of the PostgreSQL data types.
Implicit Data Type Coercion
When there is no ambiguity as to the data type of an expression value, it is implicitly coerced to match the expected data type. For example:
=> SELECT 2 + '2';
?column?
----------
4
(1 row)
The quoted string constant '2' is implicitly coerced into an INTEGER value so that it can be the operand of an arithmetic operator (addition).
=> SELECT 2 + 2 || 2;
?column?
----------
42
(1 row)
The result of the arithmetic expression 2 + 2 and the INTEGER constant 2 are implicitly coerced into a VARCHAR values so that they can be concatenated.