Re: Proposed patch: make SQL interval-literal syntax work per spec

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.