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 _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
