-
Notifications
You must be signed in to change notification settings - Fork 842
Numeric and decimal support
The Go language does not have a standard decimal type. pgx supports the PostgreSQL numeric
type out of the box. However, in the absence of a proper Go type it can only be used when translated to a float64
or string
. This is obviously not ideal.
The recommended solution is to use the github.com/shopspring/decimal package. pgx has support for integrating with this package, but to avoid a mandatory external dependency the integration is in a separate package.
To use it add the following line to your imports:
pgxdecimal "github.com/jackc/pgx-shopspring-decimal"
Then run the following to register the data type with a connection:
pgxdecimal.Register(conn.TypeMap())
If you are using pgxpool
the previous command should be run in an AfterConnect
hook to ensure it is available on every connection.
You will now be able to use a decimal.Decimal
as an query argument or scan destination.