[Kexi] Kexi 2.2 PostgreSql driver not deciphering money type

[Adam Pigg]

Hi

I assume you are talking about the migration of a pg database to a kexi 
database?

At the moment there is no check for the money type, and kexi has no direct 
mapping for this type.  I guess the nearest would be a double, but 
conversion from money > double isnt straightforward ( 
http://www.postgresql.org/docs/8.3/static/datatype-money.html ) because the 
output is local specific.

I will have a play and see if its possible.

Cheers

Adam

Noli Sicad wrote:

> Hi,
> 
> It seems that the kexi postgresql driver could not deciphering /
> understand / encode money.
> 
> In this case this table tblData.
> 
> CREATE TABLE tblData
>  (
> Croptype			varchar (32),
> Age			int,
> Area			float,
> TRV			int,
> SCOST			money,
> PCOST			money,
> P1P2			float,
> SLOG			float,
> PULP			float,
> CFREV			money,
> LCOST			money,
> TCOST			money,
> SACOST			money,
> RCOST			money
> );
> 
> 
> Thanks,
> 
> Noli