Re: scale parameter to setObject method - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: scale parameter to setObject method
Date
Msg-id Pine.BSO.4.64.0809111334200.12192@leary.csoft.net
Whole thread Raw
In response to scale parameter to setObject method  (Bob Bruynooghe <rubbish.bin1@mac.com>)
Responses Re: scale parameter to setObject method  (Bob Bruynooghe <rubbish.bin1@mac.com>)
List pgsql-jdbc

On Fri, 5 Sep 2008, Bob Bruynooghe wrote:

> I am calling the method setObject(int parameterIndex, Object x, int
> targetSqlType) with NUMERIC as the targetSqlType and a BigDecimal value of
> -92233720368.54775 as x. I expected the value placed in the database to have
> no fractional part. In fact the database contains -92233720368.54775.

I'm not sure why you expect no fraction here, the numeric type does
support fractional parts.

> I have also tried using the method setObject(int parameterIndex, Object
> x, int targetSqlType, int scale) and setting the scale explicitly. The
> value of scale is being ignored.

Yes, this is a bug in the driver.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: createArrayOf, type resolved outside search_path on arrays of composite
Next
From: Andre Bialojahn
Date:
Subject: Re: German translation fixes