Implement VarcharArray DecodeText in pgx/v5

[mvalletta]

Hi,
I'm trying to parse a varchar array column from wal2json output plugin.
This JSON coming from plugin

{
  "nextlsn": "3/A9856F98",
  "change": [
    {
      "kind": "insert",
      "schema": "public",
      "table": "label",
      "columnnames": [
        "labels"
      ],
      "columntypes": [
        "text[]"
      ],
      "columnvalues": [
        "{aaa bbb ccc}"
      ]
    }
  ]
}

With pgx/v3 this code works fine

labels := pgtype.VarcharArray{}
err := labels.DecodeText(pgConnectionInfo, []byte(w.Columnvalues[0].(string)))
if err != nil {
  panic("decoding varchar array")
}
var ll []string
if labels.Status == pgtype.Present {
  err = labels.AssignTo(&ll)
  if err != nil {
    panic"assigning labels")
  }
}

With pgx/v5 I can't found a solution
Thanks for your help

[jackc]

In pgx v5 you can scan directly into a []string or use pgtype.Array[string] or pgtype.FlatArray[string]. If you are scanning outside of a query then https://pkg.go.dev/github.com/jackc/pgx/[email protected]/pgtype#Map.Scan may do what you want.