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,
> SACOSTmoney,
> RCOST money
> );
>
>
> Thanks,
>
> Noli
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi
