Re: [SQL] Interval subtracting

Mark Dilger <pgsql(at)markdilger(dot)com> writes:
> The current code (without the patch) behaves as follows:

> select justify_days(justify_hours('1 month 95 days -36:00:00'::interval));
> justify_days
> -------------------------
> 4 mons 4 days -12:00:00

So? If we liked the current behavior we wouldn't be discussing a patch...

My thought is that justify_hours should reduce that input to
'1 month 93 days 12:00:00' and then justify_days would produce
'4 months 3 days 12:00:00'.

regards, tom lane