Re: operator suggest " interval / interval = numeric" - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: operator suggest " interval / interval = numeric"
Date
Msg-id 37ed240d0801092129h69059374y6571d78eb5de74b8@mail.gmail.com
Whole thread Raw
In response to Re: operator suggest " interval / interval = numeric"  ("Brendan Jurd" <direvus@gmail.com>)
Responses Re: operator suggest " interval / interval = numeric"  ("Warren Turkal" <wturkal@gmail.com>)
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: "Warren Turkal"
Date:
Subject: flex/bison output wrongly created in the source directory
Next
From: "Warren Turkal"
Date:
Subject: Re: operator suggest " interval / interval = numeric"