I have discovered that the jdbc driver apparently uses a default scale of zero decimal places for SQL numeric operators, including the sum() aggregate operator. For example, this query:
select (1.5 + 2);
This returns 4 from jdbc, but it returns 3.5 when run from within PGAdmin. The only way I can coerce the value to return decimal places is to explicity cast the value to a numeric with scale:
select cast(1.5 + 2 as numeric(10,2)) as value
This returns 3.5.
Also, queries like "select sum(value) from table" returns a rounded value, even though the column 'value' is numeric(16,2). Is there a magic vmparam or setting to default the precision at the jdbc driver level? I am trying to run a large existing system on PostgreSQL and it is not feasible to hunt down all numeric operations in thousands of classes to explicitly cast them. Have others have encountered this issue?
pgsql-jdbc by date
|Next:||From: Guillaume Smet||Date: 2007-01-18 14:46:26|
|Subject: Re: Memory leaks using refcursors|
|Previous:||From: Dave Cramer||Date: 2007-01-18 01:25:42|
|Subject: Re: Memory leaks using refcursors |