postgresql - How to get the absolute value of an interval

Question

Consider the following statement:

select interval '-1 hours'

I couldn't figure out how to get the absolute value of an interval, i.e. to toggle or remove the sign if negative. The only thing that came to my mind is the following:

select abs(extract(epoch from interval '-1 hours'))

But I wonder if there is a more elegant way (a way that preserves the interval type)?

Answer 1

You can find the greatest value between i and -i. For example:

SELECT greatest(-'1 hour'::interval, '1 hour'::interval);