• Tom Lane's avatar
    Make extract() do something more reasonable with infinite datetimes. · 647d87c5
    Tom Lane authored
    Historically, extract() just returned zero for any case involving an
    infinite timestamp[tz] input; even cases in which the unit name was
    invalid.  This is not very sensible.  Instead, return infinity or
    -infinity as appropriate when the requested field is one that is
    monotonically increasing (e.g, year, epoch), or NULL when it is not
    (e.g., day, hour).  Also, throw the expected errors for bad unit names.
    
    BACKWARDS INCOMPATIBLE CHANGE
    
    Vitaly Burovoy, reviewed by Vik Fearing
    647d87c5
date.out 26.8 KB