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 POEDIPIPKGJJLDNIEMBEGEKEDLAA.ron@intervideo.com
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
Oh... and I'm pretty sure noone expects this before 7.5. :-)
Looks like I'm  the only one with input files that have these
wierd-but-iso8601 'P1Y6M' and 'PT30M' inputs; so I can just
use my own patch. :-)


>
> So far,
>
>   I have submitted the input-part.
>
>   I have a working output-part (attached below, but I'm
>   still cleaning up the documentation so I'll submit another
>   one later).  The output is chosen by setting
>   the datestyle to 'iso8601basic'.
>
>   Those two changes don't break backward compatability
>   but don't fix too much odd behavior except ISO time interval I/O.
>
>
>   I was encouraged to look into changing the way timestamp
>   math is done (keeping month, and day, and second separate
>   until the end).  This is a bigger change and I don't have
>   a stable version yet, and it breaks backward compatability.
>   I hope to submit a proposal for changes early enough in the
>   7.5 timeframe to submit fixes then as well.  At the very least
>   I will fully document the existing interval-math as part of
>   this proposal so the docs can be updated even if the proposal
>   gets rejected.
>
>      Ron
>
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> > Sent: Friday, September 26, 2003 3:54 PM
> > To: Bruce Momjian
> > Cc: Ron Mayer; Peter Eisentraut; andrew@dunslane.net;
> > pgsql-patches@postgresql.org
> > Subject: Re: [PATCHES] ISO 8601 'Time Intervals' of the 'format with
> > time-unit deignators'
> >
> >
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Where did we leave this?
> >
> > I thought it was proposed work for 7.5.
> >
> >             regards, tom lane
> >
> >


pgsql-patches by date:

Previous
From: "Ron Mayer"
Date:
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Next
From: Gaetano Mendola
Date:
Subject: Waiting the patch applied