select (interval '56:48' minute to second);
result:00:56:48
select (interval '-56:48' minute to second);
result:-56:48:00
select (interval '+56:48' minute to second);
result:56:48:00
When user uses ‘+’ or ‘-‘ symbol, then minute to second range is getting
ignored.
I have checked the code and found that in function DecodeInterval(), for
timezone case (DTK_TZ) it uses INTERVAL_FULL_RANGE irrespective of range
passed by user.
However if use the range passed as argument in function DecodeInterval(),
the result of using ‘+’ or ‘-‘ is same as without using it.
Is there any particular reason for ignoring the range for DTK_TZ case in
DecodeInterval() function?
With Regards,
Amit Kapila