Summary
It is possible to perform conversions between two data types in PostgreSQL using the CREATE CAST command.
1
This command allows for the conversion of a value of one data type into another, such as the String datatype to the Integer datatype (or the Boolean datatype or datetime datatype) and vice versa.
2
According to
See more results on Neeva
Summaries from the best pages on the web
Summary
A cast specifies how to perform a conversion between two data types. For example,
converts the integer constant 42 to type float8 by invoking a previously specified function, in this case float8(int4) . (If no suitable cast has been defined, the conversion fails.)
PostgreSQL: Documentation: 9.2: CREATE CAST
postgresql.org
Summary
Cast is a technique in PostgreSQL with which we can convert a value of one datatype into another. We can perform various cast operations in PostgreSQL for converting one datatype to another, such as the String datatype to the Integer datatype (or the Boolean datatype or datetime datatype) and vice versa.
The CAST operator in PostgreSQL – SQLServerCentral
sqlservercentral.com
