Scan db jsonb field to golang struct value, in case if jsonb value in db is null, without use pointer.

[stasvo]

Lets imagine that I have table with name documents which has jsonb field with name fields.
When jsonb field value in table is not null, then all ok, jsonb value unmarshals into Fields struct, but when jsonb is null I have error because Document.Fields is not pointer. Is it exists way how possible instead of change Fields value into pointer, just get zero value of Fields struct in case if value in db tableis null instead of get error (cannot scan NULL into Fields).

type Document struct {
Name string
Fields Fields
}

type Fields struct {
RegisterNumber *string json:"register_number"
Year *uint64 json:"year"
}

[jackc]

I think in this case the simplest approach would be for Fields to implement sql.Scanner or pgtype.BytesScanner.

Note that both in application code and in pgx you have to be aware of the difference between SQL NULL and JSON null.

[stasvo]

Thank you for answer.