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

From Bruce Momjian
Subject Re: ISO 8601 "Time Intervals" of the "format with time-unit
Date
Msg-id 200312201532.hBKFWjI23029@candle.pha.pa.us
Whole thread Raw
In response to Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"  ("Ron Mayer" <ron@intervideo.com>)
List pgsql-patches
Patch applied.  Thanks.

---------------------------------------------------------------------------


Ron Mayer wrote:
> > -----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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: distinguish between all and "all" in pg_hba.conf
Next
From: Bruce Momjian
Date:
Subject: Re: fork/exec patch