Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Ron Mayer <ron@intervideo.com>
From: "Ron Mayer" <ron@intervideo.com>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: <pgsql-patches@postgresql.org>
Date: 2003-12-01T20:50:47Z
Lists: pgsql-hackers
Attachments
- iso8601intervalpatch.txt (text/plain)
> -----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