Error Messages Associated with SQLSTATE 22V02

This topic lists the errors associated with the SQLSTATE 22V02.

SQLSTATE 22V02 Description

ERRCODE_INVALID_TEXT_REPRESENTATION

Error messages associated with this SQLState

ERROR 2825: Could not convert "string"string to a boolean
ERROR 2826: Could not convert "string"string to a float8
ERROR 2827: Could not convert "string"string to an int8
ERROR 3677: Invalid input for string: "value"
ERROR 3680: Invalid input syntax for boolean: "string"
ERROR 3681: Invalid input syntax for integer: "string"
ERROR 3682: Invalid input syntax for numeric: "value"
ERROR 3711: Invalid number: "string"
ERROR 3712: Invalid numeric format string
ERROR 3714: Invalid numeric value: "string"
ERROR 3751: Invalid Session ID format
ERROR 3757: Invalid syntax for float: "string"
ERROR 3758: Invalid syntax for numeric: "string"
ERROR 3894: Malformed record literal: "string"
ERROR 4169: Not a number: "string"
ERROR 4198: Number exceeds format: "string"
ERROR 5930: Invalid numeric format string. Expected precision is value and scale is value
ERROR 8264: Invalid input syntax for type string: "string"

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.