sql：转换参数$ 1类型：不受支持的类型[] int，in中的一个切片

Question

Have this:

somevars := []int{1, 2, 3, 4}
rows, err = db.Query("SELECT c1,c2 FROM table"+tid+" WHERE c1 IN($1,$2,$3,$4);", somevars)

Got this:

sql: converting argument $1 type: unsupported type []int, a slice of int

Any way to make a slice of arguments work with lib/pq?

Answer 1

pq.Array was the answer:

somevars := []int{1, 2, 3, 4}
rows, err = db.Query("SELECT c1,c2 FROM table"+tid+" WHERE c1 = any($1);", pq.Array(somevars))