• Tom Lane's avatar
    Fix loss of fractional digits for large values in cash_numeric(). · b9d2c5c7
    Tom Lane authored
    Money values exceeding about 18 digits (depending on lc_monetary)
    could be inaccurately converted to numeric, due to select_div_scale()
    deciding it didn't need to compute any fractional digits.  Force
    its hand by setting the dscale of one division input to equal the
    number of fractional digits we need.
    
    In passing, rearrange the logic to not do useless work in locales
    where money values are considered integral.
    
    Per bug #15925 from Slawomir Chodnicki.  Back-patch to all supported
    branches.
    
    Discussion: https://postgr.es/m/15925-da9953e2674bb5c8@postgresql.org
    b9d2c5c7
money.sql 3.74 KB