• Tom Lane's avatar
    Support infinity and -infinity in the numeric data type. · a57d312a
    Tom Lane authored
    Add infinities that behave the same as they do in the floating-point
    data types.  Aside from any intrinsic usefulness these may have,
    this closes an important gap in our ability to convert floating
    values to numeric and/or replace float-based APIs with numeric.
    
    The new values are represented by bit patterns that were formerly
    not used (although old code probably would take them for NaNs).
    So there shouldn't be any pg_upgrade hazard.
    
    Patch by me, reviewed by Dean Rasheed and Andrew Gierth
    
    Discussion: https://postgr.es/m/606717.1591924582@sss.pgh.pa.us
    a57d312a
numeric.out 106 KB