Date/time types: big change
От | Thomas Lockhart |
---|---|
Тема | Date/time types: big change |
Дата | |
Msg-id | 38AAE143.82611E33@alumni.caltech.edu обсуждение исходный текст |
Ответы |
Re: [HACKERS] Date/time types: big change
Re: [HACKERS] Date/time types: big changeu Re: [HACKERS] Date/time types: big change |
Список | pgsql-hackers |
I've just committed changes to "reunify" the date/time types. "timestamp" and "interval" are now the two primary date/time types for users. Also, I've changed the default date style to "ISO" (not just in time for Y2K, but we'll be ready for "Y3K"). Also, I made some changes to have NUMERIC be a "known" type for purposes of implicit type coersion, but have not tested to see if the underlying conversion functions are available. initdb required (and enforced by a catalog version change). Regression tests pass, except for the rules test due to ongoing rules formatting work. - Thomas The detailed change log: Make NUMERIC a known native type for purposes of type coersion. Not tested. Make ISO date style (e.g. "2000-02-16 09:33") the default. Implement "date/time grand unification".Transform datetime and timespan into timestamp and interval.Deprecate datetime andtimespan, though translate to new types in gram.y.Transform all datetime and timespan catalog entries into new types.Make "INTERVAL" reserved word allowed as a columnidentifier in gram.y.Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types.date.{h,c} now deals with date, time types.timestamp.{h,c} now deals with timestamp,interval types.nabstime.{h,c} now deals with abstime, reltime, tinterval types. All regression tests pass except for rules.sql (unrelated). -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California
В списке pgsql-hackers по дате отправления: