GO array in WHERE id IN()?

Question

PostgreSQL

There is a query db.Query("SELECT * FROM words WHERE id IN ($1);", list)
And also a list slice - []int{75929,77348}
The script gives an error: converting argument $1 type: unsupported type [] int, a slice of int
How to solve the problem?

Answer 1

db.Query("SELECT * FROM words WHERE id = ANY($1);", pq.Array(list))

Answer 2

I recommend using an ORM like gorm. He definitely knows how to substitute arrays. Well, with plain queries, the chances of catching sql injection are high
. Otherwise, something like this
https://stackoverflow.com/a/38037586