Expand description
Type conversion between tokio-postgres values and oxisql_core types.
Supported Postgres types -> OxiSQL Value mapping:
| Postgres OID group | OxiSQL variant |
|---|---|
| BOOL | Value::Bool |
| INT2, INT4 | Value::I64 (widened) |
| INT8 | Value::I64 |
| FLOAT4 | Value::F64 (widened) |
| FLOAT8 | Value::F64 |
| TEXT, VARCHAR, BPCHAR, NAME | Value::Text |
| BYTEA | Value::Blob |
| DATE | Value::Date (days since Unix epoch 1970-01-01) |
| TIMESTAMP | Value::Timestamp (microseconds since Unix epoch, no tz) |
| TIMESTAMPTZ | Value::Timestamp (microseconds since Unix epoch, UTC) |
| TIME | Value::Time (microseconds since midnight) |
| UUID | Value::Uuid (u128 big-endian) |
| JSON, JSONB | Value::Json |
| NUMERIC | Value::Decimal (exact decimal string) |
| BOOL[] / INT2[] / INT4[] / INT8[] / FLOAT4[] / FLOAT8[] / TEXT[] / VARCHAR[] | Value::TypedArray |
| TIMESTAMPTZ[] / TIMESTAMP[] / DATE[] / TIME[] / UUID[] / BYTEA[] / JSON[] / JSONB[] | Value::TypedArray |
| INTERVAL | Value::Text (HH:MM:SS or “N months N days HH:MM:SS”) |
| NULL (any) | Value::Null |
| everything else | Value::Text via type-name marker |
Enums§
- Owned
Param - Owned SQL parameter that implements
ToSql.
Functions§
- pg_
row_ to_ row - Convert a
tokio_postgresPgRowinto anoxisql_coreRow. - value_
to_ param - Convert an
oxisql_core::Valueto anOwnedParam.