Re: Bug when retrieving money datatype. - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Bug when retrieving money datatype.
Date
Msg-id 9322.1322663810@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug when retrieving money datatype.  (Mikko Tiihonen <mikko.tiihonen@nitorcreations.com>)
Responses Re: Bug when retrieving money datatype.
List pgsql-jdbc
Mikko Tiihonen <mikko.tiihonen@nitorcreations.com> writes:
> I was planning to add the binary format support for money to the
> jdbc driver when I had some free time. It will solve all parsing
> problems related to locale and give nice speed boost at the same time.

I don't think that's exactly a magic bullet.  Yes, it'll mean you don't
need to know the locale's currency symbol or what it uses for decimal
point, but how are you going to determine where the decimal point is
in the binary representation?  You'll still be dependent on knowing the
server's lc_monetary locale.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Bug: Cannot pass null in Parameter in Query for ISNULL
Next
From: Craig Ringer
Date:
Subject: Re: Bug when retrieving money datatype.