Problem with data storage

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


-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice