Re: operator suggest " interval / interval = numeric"

On Jan 10, 2008 3:33 PM, Brendan Jurd <direvus@gmail.com> wrote:
> 1 month is deemed equal to 30 days, 1 day is deemed equal to 24 hours
> (although for some reason we ignore the issue of years vs. days).
>

Sorry, a correction.  The issue of years vs. days isn't ignored.  A
year is just 12 months, which yields 12 * 30 = 360 days, which is
actually a pretty significant error (1.4% on average).

# select interval '1 year' = interval '360 days';?column?
----------t
(1 row)