Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Date
Msg-id CAKFQuwaw_UhXDhveG5Sv1qivJgP5S=wVHwuwJp_cZ35DXx+EfA@mail.gmail.com
Whole thread Raw
In response to PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  ("Thangavel, Parameswaran" <Parameswaran.Thangavel@rsa.com>)
Responses Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
List pgsql-bugs
On Friday, October 16, 2020, Thangavel, Parameswaran <Parameswaran.Thangavel@rsa.com> wrote:

Any thoughts on why this behavior, Is this expected?

Not immediately, can you demonstrate the problem without using JDBC?  The JDBC project has its own issues setup on GitHub.

preparedStatement.setFloat(4, val);

    float_value numeric

Frankly, I would consider this to be an application bug, incorrectly using the API. BigDecimal maps onto numeric.

David J.

pgsql-bugs by date:

Previous
From: "Thangavel, Parameswaran"
Date:
Subject: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Next
From: Tijs van Dam
Date:
Subject: date/time special values incorrectly cached as constant in plpgsql