On Jan 10, 2008 3:33 PM, Brendan Jurd <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
