Add 'day' field to INTERVAL so 1 day interval can be distinguished from
Bruce Momjian <bruce@momjian.us>
Add 'day' field to INTERVAL so 1 day interval can be distinguished from 24 hours. This is very helpful for daylight savings time: select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours'; ?column? ---------------------- 2005-05-04 01:00:00-04 select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day'; ?column? ---------------------- 2005-05-04 01:00:00-04 Michael Glaesemann
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +17 −1 |
| src/backend/commands/variable.c | modified | +11 −1 |
| src/backend/utils/adt/date.c | modified | +4 −2 |
| src/backend/utils/adt/formatting.c | modified | +3 −3 |
| src/backend/utils/adt/nabstime.c | modified | +17 −21 |
| src/backend/utils/adt/selfuncs.c | modified | +5 −4 |
| src/backend/utils/adt/timestamp.c | modified | +193 −121 |
| src/include/catalog/pg_proc.h | modified | +5 −1 |
| src/include/catalog/pg_type.h | modified | +2 −2 |
| src/include/utils/timestamp.h | modified | +17 −13 |
| src/interfaces/ecpg/pgtypeslib/interval.c | modified | +5 −5 |
| src/test/regress/expected/interval.out | modified | +7 −7 |