Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-11 Thread Bruce Momjian
On Tue, Jun 9, 2020 at 11:18:20PM -0500, Mikhail Titov wrote: > On Wed, Jun 3, 2020 at 11:25 PM, Tom Lane wrote: > > ... > > Maybe we should just take the position that negative intervals aren't > > standardized, and if you want to transport them using ISO format then > > you first need to lobby

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-09 Thread Mikhail Titov
On Wed, Jun 3, 2020 at 11:25 PM, Tom Lane wrote: > ... > Maybe we should just take the position that negative intervals aren't > standardized, and if you want to transport them using ISO format then > you first need to lobby ISO to fix that. Apparently ISO did "fix" this. I managed to get a copy

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-03 Thread Mikhail Titov
> ... >> Umm, did you see any indication that they intend to allow "-" /anywhere/ >> in a time interval (with the exception of between year and month, month >> and day in the alternate form, as simple delimiters, not as minus? >> (Maybe you did; I'm looking at a publicly-accessible 2016 draft.) > >

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-03 Thread Mikhail Titov
On Wed, Jun 3, 2020 at 9:46 PM, Tom Lane wrote: > ... > ISTM that if the standard intended to allow that, it'd be pretty > clear. I looked through the 8601 spec just now, and I can't see any > indication whatever that they intend to allow "-" before P. To be fair, I do not have an access to 20

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-03 Thread Tom Lane
Chapman Flack writes: > On 06/03/20 22:46, Tom Lane wrote: >> "Isn't quite clear"? ISTM that if the standard intended to allow that, >> it'd be pretty clear. I looked through the 8601 spec just now, and >> I can't see any indication whatever that they intend to allow "-" before P. > Umm, did yo

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-03 Thread Chapman Flack
On 06/03/20 22:46, Tom Lane wrote: > "Isn't quite clear"? ISTM that if the standard intended to allow that, > it'd be pretty clear. I looked through the 8601 spec just now, and > I can't see any indication whatever that they intend to allow "-" before P. Umm, did you see any indication that they

Re: [PATCH] Leading minus for negative time interval in ISO 8601

2020-06-03 Thread Tom Lane
Mikhail Titov writes: > I'd like to propose a simple patch to allow for negative ISO 8601 > intervals with leading minus, e.g. -PT1H besides PT-1H. It seems that > standard isn't quite clear on negative duration. "Isn't quite clear"? ISTM that if the standard intended to allow that, it'd be pret