On 11/23/21 02:29, Ilya Anfimov wrote: > (*We > strangely don't have an absolute value operator on interval, but > I think you've got the point*).
Although tangential to the topic, that might be because a PG interval is a triple of independently-signed months/days/seconds components. An interval like '1 month -31 days +12:00:00' is positive or negative depending on the absolute date you apply it to, so what its absolute value should be isn't clear in isolation. That's also why there's no everywhere-defined conversion from PG interval to XML xs:duration or to java.time.Duration, etc.</tangent> Regards, -Chap