Implicit Type Conversion

This section describes the implicit type conversion added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.

Conversion between the fixed-length character string type CHARACTER and NUMERIC, INT4, INT8, FLOAT4, and FLOAT8
Conversion between variable-length character string type VARCHAR and NUMERIC, INT4, INT8, FLOAT4, and FLOAT8
Conversion between the text type TEXT and NUMERIC, INT2, INT4, INT8, FLOAT4, and FLOAT8
Conversion from short int INT2 to CHARACTER and VARCHAR
Conversion between binary large object BLOB and binary RAW.

Parent topic: PostgreSQL Enhanced Edition

Last Article: Data Types

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center