Re: @(#) Mordred Labs advisory 0x0001: Buffer overflow in

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
>> test=> select cash_words('-700000000000000000000000000000');
>> Minus twenty one million four hundred seventy four thousand eight
>> hundred thirty six dollars and forty eight cents

> It doesn't crash - but it sure is giving the wrong answer ;)

Well, yeah, it's only a 32-bit storage value.  Overflow per se is not
the issue here.  (One reason why I'm not excited about fixing this on an
emergency basis is that I can't believe anyone is using the money type
for any mission-critical applications... it's too limited.)
        regards, tom lane