Re: Patch for SQL-standard negative valued year-month literals

Tom Lane wrote:
>Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
>> Tom Lane wrote:
>> If I read SQL 200N's spec correctly

>> select interval '-1 1:00:00';

>> should mean "-1 days -1 hours",
>> yet 8.3 sees it as "-1 days +1 hours".

>I think we are kind of stuck on this one. If we change it, then how
>would one represent -1 days +1 hours? The spec's format is only sane
>if you assume all the fields must have the same sign, which is not
>the case for PG.

-1 days +1 hours = interval '-0 23:00:00'

Intervals are a scalar, not an addition of assorted values, alternating signs
between fields would be wrong.
--
Sincerely,
Stephen R. van den Berg.

He did a quarter of the work in *half* the time!