Re: Decimal64 and Decimal128 - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Decimal64 and Decimal128
Date
Msg-id 5604785F.7000208@BlueTreble.com
Whole thread Raw
In response to Re: Decimal64 and Decimal128  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Decimal64 and Decimal128  (Thomas Munro <thomas.munro@enterprisedb.com>)
Re: Decimal64 and Decimal128  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On 9/24/15 3:35 PM, Peter Geoghegan wrote:
> I would worry about the implicit casts you've added. They might cause problems.

Given the cycle created between numeric->decimal and decimal->numeric, I 
can pretty much guarantee they will. In any case, I don't think implicit 
casting from numeric->decimal is a good idea since it can overflow. I'm 
not sure that the other direction is safe either... I can't remember 
offhand if casting correctly obeys typmod or not.

BTW, have you talked to Pavel about making these changes to his code? 
Seems a shame to needlessly fork it. :/
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [PROPOSAL] VACUUM Progress Checker.
Next
From: Jim Nasby
Date:
Subject: Re: 9.3.9 and pg_multixact corruption