Hello > On 28.02.2018, at 13:33, pkashimalla <praveenkumar52...@gmail.com> wrote: > > Hello Team, > > We have recently migrated our database from Oracle > And there are few of my tables with numeric column type. > > In below example > I did insertion from java program with below code snippet > > Double object = 10.0; > String inserRecordQuery_NEWWAY11 = "INSERT INTO BLOB_TEST_TABLE(id)VALUES > (?)"; > selectPrepareStmt.setObject(1, object,Types.NUMERIC); > int count = selectPrepareStmt.executeUpdate(); > > it inserted like this. > / > select id from blob_test_table; > > id > numeric > ------------- > 10.0/ > > > In this case, when a decimal point is equal to 0 then, I don't want to see > the precision and the value in the column should just 10 > > And If I execute code, > > Double object = 10.5801 > String inserRecordQuery_NEWWAY11 = "INSERT INTO BLOB_TEST_TABLE(id)VALUES > (?)"; > selectPrepareStmt.setObject(1, object,Types.NUMERIC); > int count = selectPrepareStmt.executeUpdate(); > > Now ,the value in the column should be 10.5801 as the precision is greater > than ZERO > > Because of this, the migrated data (from Oracle) is without PRECISION ZERO > and the new data which is being inserted is with PRECISION ZERO. > > / > select id from blob_test_table; > > id > numeric > ------------- > 10.0 > 10 > 11 > 11.0 > / > > Is there a possible setting in PostgreSQL server to achieve this? >
I think that you should set the colomn type to real or double precision: select 10.0::double precision; 10 select 10.5801::double precision; 10.5801 Regards Charles > FYI - > > Oracle's NUMBER column type is handling it as I expected. > I migrate Oracle's NUMBER column as just NUMERIC column in PostgreSQL > > > > Thanks, > Praveen > > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html >
