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
> >
> >
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' |
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' |
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' |
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' |