Re: Proposed patch: make SQL interval-literal syntax work per spec - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Proposed patch: make SQL interval-literal syntax work per spec
Date
Msg-id 48C9B2FD.8090607@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Proposed patch: make SQL interval-literal syntax work per spec  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposed patch: make SQL interval-literal syntax work per spec  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed patch: make SQL interval-literal syntax work per spec
Next
From: Tom Lane
Date:
Subject: Re: Proposed patch: make SQL interval-literal syntax work per spec