Re: PreparedStatement rounds doubles to scale 14 during update

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(at)enterprisedb(dot)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