How to scan SQL array to []int64 in Go?

Question

I am scanning an array of int from Postgres DB and it is returning as []uint8. I need them in []int64, how can I convert them into []int64 or how can I return them from the DB as []int64? In my query I am selecting using the Array function in Postgres: Array(col1) where col1 is serial.

The error I am getting is:

unsupported Scan, storing driver.Value type []uint8 into type []int64

Ainar-G · Accepted Answer · 2016-12-01 09:39:50Z

8

If you're using github.com/lib/pq, just use Int64Array.

col1arr := []int64{}
arr := pq.Int64Array{}
err := rows.Scan(&arr)
// ...
col1arr = []int64(arr)

edited Dec 1, 2016 at 9:39

answered Dec 1, 2016 at 9:28

Ainar-G

36.5k14 gold badges103 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Said Saifi Over a year ago

can then I parse from pg.Int64Array to int64?

Said Saifi Over a year ago

thank you that is what I needed, but I am getting an error: undefined: pq.Int64Array. I imported the library

Ainar-G Over a year ago

How did you import the library? If import _ "github.com/lib/pq" then remove the _. If that doesn't help, update it with go get -u github.com/lib/pq.

Said Saifi Over a year ago

thanks I needed to update the library as you specified

Collectives™ on Stack Overflow

How to scan SQL array to []int64 in Go?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related