Tom Lane wrote:
>
> The other problem is that the SQL spec clearly defines an interval
> literal syntax, and it's not this ISO thing. So even without backward
> compatibility issues, 8601-only doesn't seem like it would fly.
>
Oh. I wasn't proposing 8601-only. Just the one-character
shorthands like '1Y1M'::interval that postgresql interprets
as "1 year one minute". No standard specifies anything close
to that; and any similar standards ask to interpret that M as
months instead of minutes.