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