Re: more problems with the money type

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>, ac(at)esilo(dot)com
Subject: Re: more problems with the money type
Date: 2007-08-20 23:23:40
Message-ID: 20070820192340.d40f582a.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 20 Aug 2007 17:32:42 -0400
"Merlin Moncure" <mmoncure(at)gmail(dot)com> wrote:
> while playing with the binary transport of the money type we found
> another bug. The following code segfaults the server on 8.3cvs:
>
> select '3'::money * 2;

What does "SELECT 2 * '3'::money;" do? If that works try changing "64"
to "32" in the function cash_mul_int4. Let me know and I will commit
the fix as soon as I get CVS access again.

> aside: since the money type was deprecated, why was it bumped to 64 bits?

See the archives.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Chernow 2007-08-21 00:00:47 Re: more problems with the money type
Previous Message Gregory Stark 2007-08-20 21:47:27 Re: 8.3 beta testing suggestions welcome