“The `pgx/v5` sql package uses the appropriate pgx types.” …マジか。やや取り回しは面倒になるけれど、PostgreSQL固有の諸々を表現できるようになるのはメリットなんだよな。乗り換えるか — Datatypes — sqlc 1.24.0 documentation #dates-and-times" target="_blank" rel="nofollow noopener">docs.sqlc.dev/en/stable/refe…

pgx/v5を使うとsql.DBが使えなくなるのか…？ それはデメリットだな、それ前提のツールが使えない

sqlcにpgxを使うよう指示すると、pgxの情報を得るわけだから、pgxのインターフェイスが要るわけで、そりゃsql.DBでその情報が得られるわけはないんだよな…仕方ない、pgxは諦めて、スキーマとクエリで工夫するか

@knaka You can use pgx/v5 as a database/sql driver: github.com/jackc/pgx/wiki…. Just make sure to remove `sql_package: pgx/v5` from your sqlc config.

@sqlcdev I specified `sql_package: pgx/v5` because I wanted to parse the `infinity` value in the timestamp column and map it to `pgtype.Timestamp`. However, by doing so, the interface changes from `database/sql`, which means I can no longer use the txdb driver for testing.

@knaka You might try overriding the timestamp database type with `pgtype.Timestamp` which doesn't require changing the database driver from `database/sql`. docs.sqlc.dev/en/latest/howt…

@sqlcdev I was able to accomplish it by following your advice, thank you! ``` - db_type: "pg_catalog.timestamptz" nullable: true go_type: import: "github⁠.com/jackc/pgtype" type: "Timestamptz" ```