Improve timestamp substraction to be DST-aware - Mailing list pgsql-hackers

From Piotr Marcinczyk
Subject Improve timestamp substraction to be DST-aware
Date
Msg-id 1385936283.6058.2.camel@centos
Whole thread Raw
Responses Re: Improve timestamp substraction to be DST-aware
List pgsql-hackers
Hi,

I would like to implement item from TODO list: "Improve TIMESTAMP WITH
TIME ZONE subtraction to be DST-aware".

To compute interval properly, we need time zone. Currently in timestamp
we don't have time zone information, so I would use actual session time
zone for computations. This can cause problems in the future, when TZ
info will be saved in DB (this is also on TODO list). In such case, user
may suspect, that stored TZ will be used, and probably behavior of
subtraction will change. Anyway, I think, that using session TZ now is
better than not using it at all.

Can I start with implementation?

Best regards
Piotr Marcinczyk




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incomplete freezing when truncating a relation during vacuum
Next
From: Tom Lane
Date:
Subject: Re: Improve timestamp substraction to be DST-aware