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 > > inco

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 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

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

2013-12-01 Thread Tom Lane
Piotr Marcinczyk 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 time > zone fo