go - 将整数传递给golang中的查询

Question

我在 golang 的查询中传递字符串时遇到问题，这是我的尝试:

Exec(`UPDATE matches SET expected_completed_at= date + interval ? second WHERE match_id in (?);`,
duration, matchIDs)

持续时间类似于 12544，查询读取为 UPDATE matches SET expected_completed_at= date + interval '12544' second WHERE match_id in (?) 我想阅读它没有单引号？

Answer 1

查询中的显式转换应该有效:

Exec(`
    UPDATE matches 
    SET 
        expected_completed_at = date + (interval $1::integer second)
    WHERE 
        match_id in ($2);
    `, duration, matchIDs)