Postgres precision loss about gorm HOT 2 CLOSED

Hi @MattNewberry

Thank you for the report. I could reproduce the issue in my local, But seems this is a bug in lib/pq

package main

import (
        "database/sql"
        "fmt"
        _ "github.com/lib/pq"
)

func main() {
        db, _ := sql.Open("postgres", "user=gorm dbname=gorm sslmode=disable")
        sql := `INSERT INTO users (latitude) VALUES ($1) RETURNING "id"`
        res, err := db.Exec(sql, 35.03554004971999)
        fmt.Println(res, err)
}

You could see the value saved into database is not correct also although gorm is not used.

So seems like lib/pg doesn't handle float64 correctly, maybe you would like to report a bug there?

https://github.com/lib/pq/issues

from gorm.

Sure thing, I'll report it there instead - Appreciate you looking into this.

from gorm.