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

From Bruce Momjian
Subject Re: ISO 8601 'Time Intervals' of the 'format with time-unit
Date
Msg-id 200312092328.hB9NSKt18747@candle.pha.pa.us
Whole thread Raw
In response to Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'  (Randolf Richardson <rr@8x.ca>)
List pgsql-patches
Randolf Richardson wrote:
> [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?

Just go with the full spellings.


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [BUGS] (Modified) Patch request for PostgreSQL 7.4 for
Next
From: Claudio Natoli
Date:
Subject: Re: Comments requested on attached fork/exec patch