Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

From: "Ron Mayer" <ron(at)intervideo(dot)com>
To: "Ron Mayer" <ron(at)intervideo(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <andrew(at)dunslane(dot)net>, <pgsql-patches(at)postgresql(dot)org>, <ron(at)cheapcomplexdevices(dot)com>
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date: 2003-09-26 23:04:37
Message-ID: POEDIPIPKGJJLDNIEMBEGEKEDLAA.ron@intervideo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers 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(at)sss(dot)pgh(dot)pa(dot)us]
> > Sent: Friday, September 26, 2003 3:54 PM
> > To: Bruce Momjian
> > Cc: Ron Mayer; Peter Eisentraut; andrew(at)dunslane(dot)net;
> > pgsql-patches(at)postgresql(dot)org
> > Subject: Re: [PATCHES] ISO 8601 'Time Intervals' of the 'format with
> > time-unit deignators'
> >
> >
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > Where did we leave this?
> >
> > I thought it was proposed work for 7.5.
> >
> > regards, tom lane
> >
> >

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2003-09-28 00:01:19 PostgreSQL conferences
Previous Message Ron Mayer 2003-09-26 22:54:58 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-26 23:20:09 Re: [GENERAL] Can't Build 7.3.4 on OS X
Previous Message Ron Mayer 2003-09-26 22:54:58 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-26 23:20:09 Re: [GENERAL] Can't Build 7.3.4 on OS X
Previous Message Ron Mayer 2003-09-26 22:54:58 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-patches by date

  From Date Subject
Next Message Gaetano Mendola 2003-09-26 23:25:49 Waiting the patch applied
Previous Message Ron Mayer 2003-09-26 22:54:58 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'