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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ron Mayer <ron(at)intervideo(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit
Date: 2003-12-20 15:32:45
Message-ID: 200312201532.hBKFWjI23029@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches


Patch applied. Thanks.

---------------------------------------------------------------------------

Ron Mayer wrote:
> > -----Original Message-----
> >
> > Is this ready for application? It looks good to me. However, there is
> > an "Open issues" section.
>
> In my mind there were two categories of open issues
> a) ones that are 100% backward (such as the comment about
> outputting this format)
> and
> b) ones that aren't (such as deprecating the current
> postgresql shorthand of
> '1Y1M'::interval = 1 year 1 minute
> in favor of the ISO-8601
> 'P1Y1M'::interval = 1 year 1 month.
>
> Attached is a patch that addressed all the discussed issues that
> did not break backward compatability, including the ability to
> output ISO-8601 compliant intervals by setting datestyle to
> iso8601basic.
>
> Ron

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

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

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Robert Treat 2003-12-20 15:37:27 Re: UserLinux with MySQL
Previous Message Greg Sabino Mullane 2003-12-20 15:29:16 Re: PostgreSQL speakers needed for OSCON 2004

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ganainm 2003-12-20 15:40:46 Re: BLOBS : how to remove them totally
Previous Message Greg Sabino Mullane 2003-12-20 15:29:16 Re: PostgreSQL speakers needed for OSCON 2004

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-12-20 16:22:11 Re: PostgreSQL speakers needed for OSCON 2004
Previous Message Greg Sabino Mullane 2003-12-20 15:29:16 Re: PostgreSQL speakers needed for OSCON 2004

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-12-20 15:32:55 pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...
Previous Message Bruce Momjian 2003-12-20 00:46:37 Re: distinguish between all and "all" in pg_hba.conf