| From: | "Ron Mayer" <ron(at)intervideo(dot)com> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators" |
| Date: | 2003-12-01 20:50:47 |
| Message-ID: | POEDIPIPKGJJLDNIEMBEOEEFEDAA.ron@intervideo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
> -----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 | Content-Type | Size |
|---|---|---|
| iso8601intervalpatch.txt | text/plain | 23.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-01 21:00:10 | Re: BSDCan 2004 |
| Previous Message | Peter Eisentraut | 2003-12-01 20:22:24 | Re: [GENERAL] PostgreSQL certifications? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-01 20:53:59 | Re: Specify a column without using its name |
| Previous Message | Randal L. Schwartz | 2003-12-01 20:42:39 | Re: Good open source mailing list system PHP / Postgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2003-12-01 21:18:20 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |
| Previous Message | Tom Lane | 2003-12-01 19:57:05 | Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2003-12-01 21:18:20 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |
| Previous Message | Tom Lane | 2003-12-01 19:57:05 | Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions? |