Type numeric mapping wrong

Claudio · Post by **Claudio** » Mon 06 Jul 2009 14:09

dbexppgsql.dll = 1.0.0.4
DELPHI 7
ENABLE BCD = TRUE

--------------------------------
select cast(0 as numeric) as tpnumeric; <----- mapping (FLOAT)

select cast(0 as numeric(10,2)) as tpnumeric; <----- mapping (FMTBCD)

----------------------------

is this a BUG ?

Plash · Post by **Plash** » Wed 12 Aug 2009 09:07

This is designed behaviour. But in the next build of the driver we will change this behaviour to use TFMTBCDField for numeric fieds without precision.