Re: Interval->day patch - Mailing list pgsql-patches

From Tom Lane
Subject Re: Interval->day patch
Date
Msg-id 23931.1121880698@sss.pgh.pa.us
Whole thread Raw
In response to Re: Interval->day patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Interval->day patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> We have this TODO item:

>         o Allow TIMESTAMP WITH TIME ZONE to store the original timezone
>           information, either zone name or offset from UTC [timezone]

>           If the TIMESTAMP value is stored with a time zone name, interval
>           computations should adjust based on the time zone rules.

> It was originally added so we could distinguish 24 hours from 1 day.  Do
> we still need this TODO?

That's a completely separate TODO item.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Interval->day patch
Next
From: Bruce Momjian
Date:
Subject: Re: Interval->day patch