pgtype
pgtype copied to clipboard
jackc
github.com/jackc/pgx and github.com/lib/pq behaviour for returned time.Time is different. `pq` uses timezone from connection and returns all `time.Time` in this timezone. For example, next code: ``` package main import (...
## Error message ``` pgtype.JSON ERROR: invalid input syntax for type json (SQLSTATE 22P02) ``` ## Description When use **pgx/v4/stdlib** and **sqlx** to store pgtype.JSON to database, will get an...
```golang var c1 pgtype.JSON config.PreferSimpleProtocol = true db := stdlib.OpenDB(config) c1.Set("[]") db.Query("INSERT INTO foo (json_field) VALUES ($1)", c1) ``` results in the following error: ``` Expected success, but got an...
I have a question about custom types registration. Can you please help me? I use PostgreSQL with [64-bit XID patch](https://commitfest.postgresql.org/41/3594/). So this means that the regular pgtype.XID is no longer...
Code in file macaddr.go ``` switch value := src.(type) { case net.HardwareAddr: // need to check if the len(value) is 0, otherwise, it want be able to insert null value...
Originally submitted to pgx repository, but the solution is a fix in this one. See https://github.com/jackc/pgx/issues/1562
Hi, first of all thank you for providing suite of libraries and drivers for the Postgres in Golang. I am working on a very big integer field that could not...
migrations ``` CREATE TABLE IF NOT EXISTS merchant ( id SERIAL NOT NULL UNIQUE, bms_whitelist INET[] NOT NULL, api_whitelist INET[] NOT NULL, ); ``` code ``` type Merchant struct{ Id...
I have struct with optional field. This optional field is not used sometimes and in such cases marshalling fails with error. Is it possible to omit such fields transparently? ```...
