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

From Randolf Richardson
Subject Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date
Msg-id Xns944615BC1835Brr8xca@200.46.204.72
Whole thread Raw
In response to Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ISO 8601 'Time Intervals' of the 'format with time-unit
List pgsql-patches
[sNip]
> ISO 8601 gives more specific names.
>
>   ISO 8601 Basic Format:         P2Y10M15DT10H20M30S
>   ISO 8601 Alternative Format:   P00021015T102030
>   ISO 8601 Extended Format:      P0002-10-15T10:20:30
>
> In a way, the Extended Format is kinda nice, since it�s
> almost human readable.
>
> I could put in both the basic and extended ones, and
> call the dateformats �iso8601basic� and �iso8601extended�.
> The negative is that to do �iso8601basic� right, I�d also
> have to tweak the �date� and �time� parts of the code too.

        Perhaps all three formats should be supported, and if the following
names were all valid things could be simplified further too:

                iso8601basic
                iso8601bas
                iso8601alternative
                iso8601alt
                iso8601extended
                iso8601ext

        The reason for allowing shorter names is to simplify database
management for anyone who may need to store the format name in a column for
some reason (I can't think of one now, but I get a feeling that someone
will want to do this type of thing in the future).

        For that matter, the first letter could be used instead of the first
three for the short versions.  Any thoughts on this?

--
Randolf Richardson - rr@8x.ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

pgsql-patches by date:

Previous
From: "ViSolve Open Source Team"
Date:
Subject: Re: [BUGS] (Modified) Patch request for PostgreSQL 7.4 for HP-UX IA-64
Next
From: Andrew Dunstan
Date:
Subject: Re: [BUGS] (Modified) Patch request for PostgreSQL 7.4