On Jan 10, 2008 3:33 PM, Brendan Jurd <direvus(at)gmail(dot)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)