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

From: "Ron Mayer" <ron(at)intervideo(dot)com>
To: "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>, <ron(at)intervideo(dot)com>
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date: 2003-09-26 22:54:58
Message-ID: POEDIPIPKGJJLDNIEMBEOEKDDLAA.ron@intervideo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches


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

Attachment Content-Type Size
iso_time_interval_input.txt text/plain 24.6 KB

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Ron Mayer 2003-09-26 23:04:37 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Tom Lane 2003-09-26 22:54:09 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2003-09-26 23:04:37 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Tom Lane 2003-09-26 22:54:09 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-hackers by date

  From Date Subject
Next Message Ron Mayer 2003-09-26 23:04:37 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Tom Lane 2003-09-26 22:54:09 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

Browse pgsql-patches by date

  From Date Subject
Next Message Ron Mayer 2003-09-26 23:04:37 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Tom Lane 2003-09-26 22:54:09 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'