Re: [PATCHES] [SQL] Interval subtracting

2006-03-01 Thread Mark Dilger
Mark Dilger wrote: Mark Dilger wrote: Tom Lane wrote: "Milen A. Radev" <[EMAIL PROTECTED]> writes: Milorad Poluga напи�а: SELECT '10 years 1 mons 1 days'::interval - '9 years 10 mons 15 days'::interval ?column?--- 3 mons -14 days Why not '2 mons 16 days' ?

Re: [PATCHES] [SQL] Interval subtracting

2006-03-03 Thread Mark Dilger
Attached is the new patch. To summarize: - new function justify_interval(interval) - modified function justify_hours(interval) - modified function justify_days(interval) These functions are defined to meet the requirements as discussed in this thread. Specifically: - justify_hours m