Re: Bug when retrieving money datatype.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug when retrieving money datatype.
Дата
Msg-id 9322.1322663810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug when retrieving money datatype.  (Mikko Tiihonen <mikko.tiihonen@nitorcreations.com>)
Ответы Re: Bug when retrieving money datatype.  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Bug: Cannot pass null in Parameter in Query for ISNULL
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Bug when retrieving money datatype.