Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] data export has strange decimal values - Mailing list pgsql-admin

From Marc Fromm
Subject [ADMIN] data export has strange decimal values
Date
Msg-id CY1PR0201MB14365168F96CF795B33A18629D680@CY1PR0201MB1436.namprd02.prod.outlook.com
Whole thread Raw
Responses Re: [ADMIN] data export has strange decimal values  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin
Tree view

I’m using postgresql9.2. When I export some data using phppgadmin some decimal values are exported as 9.4700003 instead of 9.47 (they show as 9.47 in phppgadmin and when displayed on the web. Others export as 9.5299997 instead of 9.53 (again they show as 9.53 in phppgadmin and when displayed on the web).

 

The data type for the field is set as type “real.” Is this data type causing the problem and I should change it to decimal?

 

What could be creating this plus or minus 0.0000003 to the recorded value?

 

Thanks

 

Marc

 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] localized fulltext search
Next
From: Steve Crawford
Date:
Subject: Re: [ADMIN] data export has strange decimal values