Add support for input and output of interval values formatted per ISO 8601;
Tom Lane <tgl@sss.pgh.pa.us>
Add support for input and output of interval values formatted per ISO 8601; specifically, we can input either the "format with designators" or the "alternative format", and we can output the former when IntervalStyle is set to iso_8601. Ron Mayer
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +4 −1 |
| doc/src/sgml/datatype.sgml | modified | +127 −5 |
| src/backend/utils/adt/datetime.c | modified | +356 −14 |
| src/backend/utils/adt/nabstime.c | modified | +7 −1 |
| src/backend/utils/adt/timestamp.c | modified | +9 −2 |
| src/backend/utils/misc/guc.c | modified | +2 −1 |
| src/bin/psql/tab-complete.c | modified | +2 −2 |
| src/include/miscadmin.h | modified | +6 −4 |
| src/include/utils/datetime.h | modified | +6 −4 |
| src/test/regress/expected/interval.out | modified | +51 −0 |
| src/test/regress/sql/interval.sql | modified | +35 −0 |