In my mind there were two categories of open issues
Bruce Momjian <bruce@momjian.us>
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.
Interval values can now be written as ISO 8601 time intervals, using
the "Format with time-unit designators". This format always starts with
the character 'P', followed by a string of values followed
by single character time-unit designators. A 'T' separates the date and
time parts of the interval.
Ron Mayer
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/datatype.sgml | modified | +62 −1 |
| src/backend/commands/variable.c | modified | +10 −2 |
| src/backend/utils/adt/datetime.c | modified | +379 −2 |
| src/include/miscadmin.h | modified | +4 −1 |
| src/interfaces/ecpg/pgtypeslib/dt_common.c | modified | +55 −0 |
| src/interfaces/ecpg/pgtypeslib/dt.h | modified | +1 −0 |
| src/interfaces/ecpg/pgtypeslib/interval.c | modified | +67 −1 |