pgxV5 json_agg array scan

[dankobg]

How to scan json_agg array result into slice. It worked before but not sure how to do this with pgxV5?
Is this not yet possible or i need to use custom type that implements Scan and Value?
i get this err:

jet: can't assign []interface {}([map["name":"Affectionate"] map["name":"Sweet"] map["name":"Friendly"] map["name":"Gentle"]]) to 'Tags []model.AnimalTag': value not convertable to []byte

func main() {
	q := p.SELECT(
		t.Animal.Name,
		p.SELECT_JSON_ARR(t.AnimalTag.Name).
			FROM(t.AnimalTag).
			WHERE(t.AnimalTag.AnimalID.EQ(t.Animal.ID)).
			AS("tags"),
	).
		FROM(t.Animal).
		WHERE(t.Animal.ID.EQ(p.Int64(1)))

    var dest struct {
		model.Animal
		Tags []model.AnimalTag `json_column:"tags"`
	}
	if err := pgxV5.Query(ctx, q, pool, &dest); err != nil {
		log.Fatal(err)
	}
	fmt.Println(dest)
}

[go-jet]

How to scan json_agg array result into slice. It worked before but not sure how to do this with pgxV5?
Is this not yet possible or i need to use custom type that implements Scan and Value?

Yeah, you'll need to implement Scan method. Its one of the issues with pgx. I didn't find a good way to get a raw bytes from the driver. The driver by default always returns map[string]interface{}.

[dankobg]

I implemented Scan for that TagSlice, which is []any of map[string]any and it works but i had to remove that comment in dest that json_column. With the comment, i would still get the same error, maybe i was doing something wrong, i don't know.

type TagSlice []model.Tag
var dest struct {
  model.Animal
  Tags TagSlice `json_column:"tags"` // had to remove this
}

Also i had to do some type conversions which is little weird. I had this:

#[]interface {} [
  0 => #map[string]interface {} {
     updatedAt => "2026-01-28T14:43:20.248628+00:00" #string
     id => 4.000000 #float64
     animalID => 10.000000 #float64
     name => "Affectionate" #string
     createdAt => "2026-01-28T14:43:20.248628+00:00" #string
  }
  1 => #map[string]interface {} {
     id => 7.000000 #float64
     animalID => 10.000000 #float64
     name => "Friendly" #string
     createdAt => "2026-01-28T14:43:20.248628+00:00" #string
     updatedAt => "2026-01-28T14:43:20.248628+00:00" #string
  }
]

I had to convert from float64 to int64, and timestamps were strings, that's the default deserialization into a generic map