Data Type

by **iulian** on Tue May 09, 2006 12:26 am

Hi, when I import numeric data from a txt file (I define the data = double type in text struncture) in a table from postgres (data defined = numeric), in the table the data arrived truncated (without decimals). Please, could you help me with this issue?

If in postgres table I have type = numeric(10,2) and in flat file or in another table I have any numeric type, I can not import the decimals. Why?. If I change in postgres type in float(4) the decimals are imported but altered.

by **Henrik Nordberg** on Tue May 09, 2006 11:16 am

iulian wrote:Hi, when I import numeric data from a txt file (I define the data = double type in text struncture) in a table from postgres (data defined = numeric), in the table the data arrived truncated (without decimals). Please, could you help me with this issue?

Due to a bug, numeric was treated as int. This will be fixed in release 0.9.11, which is due out within days.

iulian wrote:If in postgres table I have type = numeric(10,2) and in flat file or in another table I have any numeric type, I can not import the decimals. Why?. If I change in postgres type in float(4) the decimals are imported but altered.

This is due to the above bug, in addition to a rounding error (which has already been fixed). This case should work correctly in version 0.9.11.

Cheers
- Henrik

Data Type

Data Type

Re: Data Type