Re: Money type and kylix - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Money type and kylix
Date
Msg-id web-699696@davinci.ethosmedia.com
Whole thread Raw
In response to Money type and kylix  ("Eduardo" <eduardo_duv@bol.com.br>)
List pgsql-sql
Eduardo,

>    I m trying to use a field with type money in a kylix application,
>  but it doesn't work. It always says: "dbx error: incompatible type".
>  
>    Is it possible to use the money field with kylix or do i have to
>  search for another solution?

Umm .. this is a PostgreSQL list.  Are you using Kylix with PostgreSQL? 

If so, you need to use the data type NUMERIC(#,#) to emulate a "money"type.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: nexval error duplicate key
Next
From: david blood
Date:
Subject: current connections and queries