Problem with data storage - Mailing list pgsql-novice

Hi,

I'm still doing test with PostgreSQL with C++ Builder using MicroOLAP DAC
and one big problem I have is with numerical data type.

Suppose the following table:
CREATE TABLE "TestNumbers"
(
   "TestInteger" integer,
   "TestReal" real,
   "TestMoney" money,
   "TestDouble" double precision,
   "TestNumeric" numeric(20,2)
);

Now, after adding a record with the value 22443018 for each fields I
finally have the following values:
TestInteger: 22443018
TestReal:    22443000
TestMoney:   {get a read error at 0x00000000, probably microOLAP DAC
related}
TestDouble:  {empty/no value displayed}
TestNumeric  {empty/no value displayed}

Using pgAdmin III, I see the same values.

Now Inserting data in the table using pgAdmin III:
INSERT INTO "TestNumbers"(
             "TestInteger", "TestReal", "TestMoney", "TestDouble",
"TestNumeric")
     VALUES ('22443018', '22443018', '22443018', '22443018', '22443018');

The results are in pgAdmin are:
TestInteger: 22443018
TestReal:    2.2443e+007
TestMoney:   -$20,506,654.96
TestDouble:  22443018
TestNumeric: 22443018.00

And looking at this record from C++ Builder, I have the following values:
TestInteger: 22443018
TestReal:    22443000
TestMoney:   -$20,506,654.96
TestDouble:  {empty/no value displayed}
TestNumeric: {empty/no value displayed}

I have made the same test with a simple Paradox table, and all values are
displayed correctly.

Does anybody knows why the rounding occurs, why the negative value and why
the blank value?


Thanks a lot
Francois