Re: [HACKERS] Improve timestamp substraction to be DST-aware

2014-03-08 Thread Bruce Momjian
On Mon, Dec 2, 2013 at 11:43:06PM +0100, Piotr Marcinczyk wrote: The alternative proposal that's been on the table for awhile (see the preceding entry in the TODO list) is to remove the interval_justify_hours call in timestamp_mi, which would also have the effect of fixing the

Re: [HACKERS] Improve timestamp substraction to be DST-aware

2013-12-02 Thread Piotr Marcinczyk
On Sun, 2013-12-01 at 17:40 -0500, Tom Lane wrote: Piotr Marcinczyk pmarc...@gmail.com writes: 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

Re: [HACKERS] Improve timestamp substraction to be DST-aware

2013-12-01 Thread Tom Lane
Piotr Marcinczyk pmarc...@gmail.com writes: 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