Re: PreparedStatement rounds doubles to scale 14 during update - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: PreparedStatement rounds doubles to scale 14 during update
Date
Msg-id 744C1E7C-0524-48E0-A8CD-2CCBF8C84C5F@fastcrypt.com
Whole thread Raw
In response to Re: PreparedStatement rounds doubles to scale 14 during update  ("Peter Kovacs" <maxottovonstirlitz@gmail.com>)
Responses Re: PreparedStatement rounds doubles to scale 14 during update  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-jdbc
On 5-Sep-07, at 9:13 AM, Peter Kovacs wrote:

> Thank you for the python reference, it is very instructive indeed.
>
> I find it strange that the type mapping specification is in a tutorial
> by Sun and not in a more formal document.
>
Welcome to SUN API documentation ....

Dave
> Thanks
> Peter
>
> On 9/5/07, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>> Peter Kovacs wrote:
>>> Heikki,
>>>
>>> Thank you for your reply.
>>>
>>> What are base-10 datatypes? Are they numeric types? I cannot find
>>> them
>>> in the backend documentation.
>>
>> I meant any data type that can accurately represent a base-10 decimal
>> number. In PostgreSQL, that's numeric. In Java, it's BigDecimal.
>>
>> If you're not familiar with the differences between floating point
>> and
>> decimal numbers, I'd suggest you to read on it. This python
>> tutorial for
>> example has a pretty good chapter on the issues:
>> http://docs.python.org/tut/node16.html
>>
>>> Is there a mapping of Java types to backend types documented
>>> somewhere?
>>
>> There is for mapping between Java types and SQL types, see "Getting
>> Started with with the JDBC API" by Sun:
>>
>> http://java.sun.com/j2se/1.5.0/docs/guide/jdbc/getstart/mapping.html
>>
>> --
>>   Heikki Linnakangas
>>   EnterpriseDB   http://www.enterprisedb.com
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend


pgsql-jdbc by date:

Previous
From: "Peter Kovacs"
Date:
Subject: Re: PreparedStatement rounds doubles to scale 14 during update
Next
From: Oliver Jowett
Date:
Subject: Re: PreparedStatement rounds doubles to scale 14 during update