Re: AW: Re: tinterval - operator problems on AIX - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: AW: Re: tinterval - operator problems on AIX
Date
Msg-id 3A5F1AC1.38259F5F@alumni.caltech.edu
Whole thread Raw
In response to AW: Re: tinterval - operator problems on AIX  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Responses Re: AW: Re: tinterval - operator problems on AIX
List pgsql-hackers
> Here is the program.  The call to localtime(&t_ago) is redundant and
> hence the adjustment of t_ago can be skipped.  It is in this program
> as a sanity check.
> As it stands, this program assumes that the input and resulting date
> are in the usual UNIX range of [1901, 2038].  I presume that there is
> code in place that checks the range of dates.

Interesting idea. I'm not sure that assuming that timezones from 1943
are the same as timezones from 2013 (they are not, at least in the US)
is any more valid than just accepting the result from your system. I'd
like to explore more possibilities before we settle on a solution.

Perhaps I should just add checks to assume an unspecified time zone wrt
output formatting if the tm_isdst flag comes back as "-1"?

I'll have to look at the ramifications for input times and for
dump/restore operations. Does you system respect the TZ or PGTZ
environment variable?
                        - Thomas


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: AW: Re: GiST for 7.1 !!
Next
From: Tom Lane
Date:
Subject: Re: AW: Re: GiST for 7.1 !!