• Tom Lane's avatar
    Make handling of INTERVAL DAY TO MINUTE and INTERVAL DAY TO SECOND input · 5cca35a6
    Tom Lane authored
    more consistent with other cases, by having an unlabeled integer field
    be treated as a number of minutes or seconds respectively.  These cases
    are outside the spec (which insists on full "dd hh:mm" or "dd hh:mm:ss"
    input respectively), so it's not much help to us in deciding what to do.
    But with this change, it's uniformly the case that an unlabeled integer
    will be considered as being a number of the interval's rightmost field.
    The change also takes us back to the 8.3 behavior of throwing error
    for certain ambiguous inputs such as INTERVAL '1 2' DAY TO MINUTE.
    Per recent discussion.
    5cca35a6
datetime.c 106 KB