Tom Lane wrote:
> Bruce Momjian 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, inte
Bruce Momjian 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
I have applied this patch with significant adjustments. I changed your
"simplify" function into two new functions, justify_hours() and
justify_days(), to handle the adjustment of interval values to hours <
24 and days < 30. Do we want to separate functions?
I used date2j and j2date to add days
I am close to completing work on this patch and will post an updated
version in a few days.
---
Michael Glaesemann wrote:
> Please find attached a patch which adds a day field to the interval
> struct so that we can treat
Please find attached a patch which adds a day field to the interval
struct so that we can treat INTERVAL '1 day' differently from
INTERVAL '24 hours' in DST-aware situations. It also includes a
function called interval_simplify() which takes an interval argument
and returns an interval wher