Re: Bug extracting money value

On 1-Oct-06, at 5:11 PM, Oliver Jowett wrote:

> Holger Schulz wrote:
>
>> I always get an exception when I try to extract the money value I
>> inserted this way:
>
> "money" isn't a well-supported type on the server side (I believe
> its use is no longer recommended)
This is still being debated, and will likely be reversed as there is
a proposal on the table for a new improved money type

> .. IIRC the formatting rules for it are locale-specific, among
> other problems.
>
>> Object oValue = m_resultSet.getObject(i);
>
>> org.postgresql.util.PSQLException: Bad value for type double : ?7,00
>
> ... though I'd expect at least getObject to work, if not getDouble()
>
> Maybe you could dig into this and send us a patch?
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>