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 to
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
Tom Lane wrote:
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
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