> ## Documentation Index
> Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Type conversion table

| **Source type** | **Target type** | **Function (1)** | **Implicit?** |
| :-------------- | :-------------- | :--------------- | :------------ |
| INT8            | INT4            | INT4             | In assignment |
| INT8            | INT2            | INT2             | In assignment |
| INT8            | DECIMAL         | DECIMAL          | yes           |
| INT8            | FLOAT8          | FLOAT8           | yes           |
| INT8            | FLOAT4          | FLOAT4           | yes           |
| INT8            | BOOLEAN         | BOOL             | no            |
| INT8            | VARCHAR         | TEXT             | In assignment |
| INT4            | INT8            | INT8             | yes           |
| INT4            | INT2            | INT2             | In assignment |
| INT4            | DECIMAL         | DECIMAL          | yes           |
| INT4            | FLOAT8          | FLOAT8           | yes           |
| INT4            | FLOAT4          | FLOAT4           | yes           |
| INT4            | BOOLEAN         | BOOL             | no            |
| INT4            | VARCHAR         | TEXT             | In assignment |
| INT2            | INT8            | INT8             | yes           |
| INT2            | INT4            | INT4             | yes           |
| INT2            | DECIMAL         | DECIMAL          | yes           |
| INT2            | FLOAT8          | FLOAT8           | yes           |
| INT2            | FLOAT4          | FLOAT4           | yes           |
| INT2            | BOOLEAN         | BOOL             | no            |
| INT2            | VARCHAR         | TEXT             | In assignment |
| DECIMAL         | INT8            | INT8             | In assignment |
| DECIMAL         | INT4            | INT4             | In assignment |
| DECIMAL         | INT2            | INT2             | In assignment |
| DECIMAL         | DECIMAL         | DECIMAL          | yes           |
| DECIMAL         | FLOAT8          | FLOAT8           | yes           |
| DECIMAL         | FLOAT4          | FLOAT4           | yes           |
| DECIMAL         | VARCHAR         | TEXT             | In assignment |
| FLOAT8          | INT8            | INT8             | In assignment |
| FLOAT8          | INT4            | INT4             | In assignment |
| FLOAT8          | INT2            | INT2             | In assignment |
| FLOAT8          | DECIMAL         | DECIMAL          | In assignment |
| FLOAT8          | FLOAT4          | FLOAT4           | In assignment |
| FLOAT8          | VARCHAR         | TEXT             | In assignment |
| FLOAT4          | INT8            | INT8             | In assignment |
| FLOAT4          | INT4            | INT4             | In assignment |
| FLOAT4          | INT2            | INT2             | In assignment |
| FLOAT4          | DECIMAL         | DECIMAL          | In assignment |
| FLOAT4          | FLOAT8          | FLOAT8           | yes           |
| FLOAT4          | VARCHAR         | TEXT             | In assignment |
| VARCHAR         | CHARACTER       | none (2)         | yes           |
| VARCHAR         | VARCHAR         | TEXT             | yes           |
| CHARACTER (3)   | CHARACTER       | BPCHAR           | yes           |
| CHARACTER       | VARCHAR         | TEXT             | yes           |
| BOOLEAN         | INT8            | INT8             | no            |
| BOOLEAN         | INT4            | INT4             | no            |
| BOOLEAN         | INT2            | INT2             | no            |
| BOOLEAN         | VARCHAR         | TEXT             | In assignment |
| BOOLEAN         | CHARACTER       | none             | In assignment |
| TIMESTAMP       | VARCHAR         | TEXT             | In assignment |
| TIMESTAMP       | DATE            | DATE             | In assignment |
| TIMESTAMP       | TIME            | TIME             | In assignment |
| DATE            | VARCHAR         | TEXT             | In assignment |
| DATE            | TIMESTAMP       | TIMESTAMP        | yes           |
| TIME            | VARCHAR         | TEXT             | In assignment |
| UUID            | VARCHAR         | none             | In assignment |
| UUID            | CHARACTER       | none             | In assignment |
| VARCHAR         | UUID            | none             | No            |
| CHARACTER       | UUID            | none             | No            |

Notes:

(1) Function: The name of an explicit conversion function (e.g `SELECT FLOAT8(5.2)`)
(2) ‘none’ means there is no explicit conversion function for this case.
(3) Conversion from `CHAR(n)` to the `CHAR(m)` where `M != n`.