Re: tinterval - operator problems on AIX
От | Thomas Lockhart |
---|---|
Тема | Re: tinterval - operator problems on AIX |
Дата | |
Msg-id | 3A5B28DB.19450D3E@alumni.caltech.edu обсуждение исходный текст |
Ответ на | tinterval - operator problems on AIX (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>) |
Список | pgsql-hackers |
> On AIX timestamp and horology regression fails in current, because > timestamp - interval for result timestamps that are before 1970 (epoch ?) > are off by one hour. I think this is not an issue for an adapted expected file, > but a new (in 7.1beta) bug. But I am at no means an expert at what the result > should be when substracting 34 years from epoch or 'Mon Dec 30 17:32:01 1996 PST'. Hi Andreas. It is certainly true that the behavior has changed for the new release, but afaik it can not be put into the "bug" category. The difference is that, before, I rotated date/time into the correct time zone for arithmetic by adding/subtracting the current time zone. For (date/time)-(interval), this resulted in evaluating the result in the same time zone as the starting date/time, which was not correct. The time zone is now evaluated in the time zone of the result, rather than the input, using system support routines from libc. But that will expose troubles on some platforms with time zone support before 1970. Some platforms are worse than others; my experience has been that zinc-based systems such as Linux, FreeBSD, and Tru64 are pretty good, Suns are the best, and, well, apparently AIX is not ;) - Thomas
В списке pgsql-hackers по дате отправления: