launchbadge / sqlx

🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
Apache License 2.0
13.32k stars 1.27k forks source link

Any driver will fail to get decimal column value from postgres database, the same for date and timestamp column type . #3521

Open swfdoudou opened 1 month ago

swfdoudou commented 1 month ago

Bug Description

When i get decimal column value from postgres by Any driver, the library panic : Any driver does not support the Postgres type PgTypeInfo(Numeric) the samilar error for the timestamp and date column type , it's : Any driver does not support the Postgres type PgTypeInfo(Timestamptz)

Info

CommanderStorm commented 1 month ago

You created both this issue and a discussion https://github.com/launchbadge/sqlx/discussions/3520

swfdoudou commented 3 weeks ago

JDBC(java) and ODBC(c、C++) also is database agnostic, but they all support the decimal and Date(datetime) types. Decimal and Date(datetime) types are so commonly used in databases and application , hope to add support to them.