Numerics in pgx/v5

main.go

package main

import (
	"fmt"

	"github.com/jackc/pgx/v5/pgtype"
)

func main() {
	var num pgtype.Numeric
	if err := num.Scan(updateCustomerObj.DiscountPercentage); err != nil {
		fmt.Println(err)
		return
	}

	sqlc.UpdateCustomersParams{
		SetDiscountPercentage: 	!(updateCustomerObj.DiscountPercentage == 0),
		DiscountPercentage:   	*num
	}

	fmt.Printf("output: %s", output)
}