I use Go and Postgres (with pgx driver)
In my Postgres table I have a field with array of integers. I have created a variable to store array of integers after scanning.
var ids pgtype.Int4Array
How to convert ids to []int64?
Asked
Active
Viewed 2,112 times
0
-
2`pgtype.Int4Array` implements `sql.Scanner`, so just use [`Row.Scan`](https://golang.org/pkg/database/sql/#Row.Scan) as normal. – Jonathan Hall Aug 20 '19 at 16:13
-
1@Flimzy Sorry, I did not understand. – Klimbo Aug 20 '19 at 16:15
-
1Please show the code you're having trouble with. It will be much easier to offer an explicit suggestion that way. – Jonathan Hall Aug 20 '19 at 16:16
-
1@Flimzy I do it this way: `row := tx.QueryRow(q)` `row.Scan(&ids)` – Klimbo Aug 20 '19 at 16:16
-
3`ids.AssignTo(&sliceOfInt64)` – Charlie Tumahai Aug 20 '19 at 16:17
-
1@CeriseLimón Thank you so mush! I have read the docs, but there are no comments in code. So it was a problem for me to find the solution – Klimbo Aug 20 '19 at 16:19
