justify_interval: days in year - Mailing list pgsql-general

From Ilya Ashchepkov
Subject justify_interval: days in year
Date
Msg-id 20141110150748.2ee99776@moni.nskavd.local
Whole thread Raw
Responses Re: justify_interval: days in year  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Hello!

Is this correct?
$ select
  justify_interval(t-f-i)
  ,t-f-i
from
  (
    select
      timestamp '2014-1-1' as f,
      timestamp '2015-1-1' as t,
      interval '06:49:00' as i
  ) S;

    justify_interval    |      ?column?
------------------------+--------------------
 1 year 4 days 17:11:00 | 365 days -06:49:00

Why do we have 360 days in a year?

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Query Plans on Slaves
Next
From: Jehan-Guillaume de Rorthais
Date:
Subject: Strange avg value size for index on expression in pg_stats