Types
The CAST syntax conforms to SQL; the syntax with :: is historical PostgreSQL usage. — Type Casts
- Numeric
- Monetary
- Character
- Binary
- Date/Time
- Boolean
- Enumerated
- Geometric
- Network Address
- Bit String
- Text Search
- UUID
- XML
- JSON
- Arrays
- Composite
- Range
- Domain
- Object Identifier
- pg_lsn
- Pseudo