package main

import (
    "fmt"

    "github.com/alexandergrom/qp"
)

func main()  {

    var query = qp.Format(
        "SELECT COUNT(*) FROM xx.yy WHERE id = %p AND type IN (%p)",
        1,
        []uint8{10, 12},
    )

    fmt.Println(query.String(), query.Params())

}


// SELECT COUNT(*) FROM xx.yy WHERE id = $1 AND type IN ($2) [1 [10 12]]



package main

import (
    "fmt"

    "github.com/alexandergrom/qp"
)

func main()  {

    var query = qp.Format(
        "SELECT COUNT(*) FROM xx.yy WHERE id = %p AND type IN (%p)",
        1,
        []int64{10, 12},
    )

    fmt.Println(query.String(), query.Params())

}


// SELECT COUNT(*) FROM xx.yy WHERE id = $1 AND type IN ($2, $3) [1 10 12]