Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators" - Mailing list pgsql-patches

From Ron Mayer
Subject Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Date
Msg-id POEDIPIPKGJJLDNIEMBEOEEFEDAA.ron@intervideo.com
Whole thread Raw
In response to Re: ISO 8601 "Time Intervals" of the "format with time-unit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ISO 8601 "Time Intervals" of the "format with time-unit
Re: ISO 8601 "Time Intervals" of the "format with time-unit
List pgsql-patches
> -----Original Message-----
>
> Is this ready for application?  It looks good to me.  However, there is
> an "Open issues" section.

In my mind there were two categories of open issues
  a) ones that are 100% backward (such as the comment about
     outputting this format)
and
  b) ones that aren't (such as deprecating the current
     postgresql shorthand of
         '1Y1M'::interval = 1 year 1 minute
     in favor of the ISO-8601
         'P1Y1M'::interval = 1 year 1 month.

Attached is a patch that addressed all the discussed issues that
did not break backward compatability, including the ability to
output ISO-8601 compliant intervals by setting datestyle to
iso8601basic.

   Ron

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?
Next
From: "Ron Mayer"
Date:
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit