query := "WITH b(ColA, ColB) AS (VALUES ($1,$2)) UPDATE schema_name.table_name AS a SET ColC = b.ColB FROM b WHERE a.ColA = b.ColA AND a.ColB = b.ColB"
res, err := db.Exec(query, 1, 1)
The above code fails with the following error:
pq: operator does not exist: bigint = text
"ColC" is of type BIGINT.
From my investigation, the driver is inserting the values as text instead of ints.