From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Marc G. Fournier <scrappy@hub.org>
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] More patches for date/time I have accumulated several patches to add functionality to the datetime and timespan data types as well as to fix reported porting bugs on non-BSD machines. These patches are: dt.c.patch - add datetime_part(), fix bugs dt.h.patch - add quarter and timezone support, add prototypes globals.c.patch - add time and timezone variables miscadmin.h.patch - add time and timezone variables nabstime.c.patch - add datetime conversion routine nabstime.h.patch - add prototypes pg_operator.h.patch - add datetime operators, clean up formatting pg_proc.h.patch - add datetime functions, reassign conflicting date OIDs pg_type.h.patch - add datetime and timespan data types The dt.c and pg_proc.h patches are fairly large; the latter mostly because I tried to get some columns for existing entries to line up.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/dt.c | modified | +939 −421 |
| src/backend/utils/adt/nabstime.c | modified | +105 −50 |
| src/backend/utils/init/globals.c | modified | +3 −2 |
| src/include/catalog/pg_operator.h | modified | +47 −20 |
| src/include/catalog/pg_proc.h | modified | +179 −150 |
| src/include/catalog/pg_type.h | modified | +60 −38 |
| src/include/miscadmin.h | modified | +18 −2 |
| src/include/utils/dt.h | modified | +101 −20 |
| src/include/utils/nabstime.h | modified | +5 −3 |