Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7963=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WXiC6-0008Pc-0P
 for pgsql-docs@arkaria.postgresql.org; Wed, 09 Apr 2014 02:24:54 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7963=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WXiC5-0000cR-AQ
 for pgsql-docs@arkaria.postgresql.org; Wed, 09 Apr 2014 02:24:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <nuko.yokohama@gmail.com>) id 1WVYnZ-00071g-LG
 for pgsql-docs@postgresql.org; Thu, 03 Apr 2014 03:58:41 +0000
Received: from mail-la0-x229.google.com ([2a00:1450:4010:c03::229])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <nuko.yokohama@gmail.com>) id 1WVYnW-0003LB-Iq
 for pgsql-docs@postgresql.org; Thu, 03 Apr 2014 03:58:41 +0000
Received: by mail-la0-f41.google.com with SMTP id gl10so897382lab.0
 for <pgsql-docs@postgresql.org>; Wed, 02 Apr 2014 20:58:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=IWftYf+uADBnmc0RgW0wxJa88snWhQ/1d/xQhaLQNXU=;
 b=QX+u+xQbr2pN704yUEyscbWiV+X19p2KZVOHrIJqjgEkYZ+vRuu/6avGxOg+G+LElV
 fsnV98ZInzKwWqAoMTJ1k/gB4h9A/V59DS9jDDlN5FphTJKigO4nCX5FmUfbz+sz3xbP
 zoGc8nfWdjpyZ9iL39w/KucQp/3efo2EG/gNhxmclIBrnymjPpI6ZQ+4c/yB3ldDy9Kq
 fSyZTtOvQSvPry4KTVgZtkwbTWlbHbx//vF4RXC+VlaM9UjVZvvFQMevR5jJAktU6Pgp
 aI01QLOIEfiqmPYCGzH+Ih+hRhiLhhFPMLMXEwpiQCbT97CgLurx+F4FLQ4+TeDpyb6U
 GkuQ==
MIME-Version: 1.0
X-Received: by 10.112.13.70 with SMTP id f6mr2721080lbc.5.1396497517661; Wed,
 02 Apr 2014 20:58:37 -0700 (PDT)
Received: by 10.112.26.78 with HTTP; Wed, 2 Apr 2014 20:58:37 -0700 (PDT)
Date: Thu, 3 Apr 2014 12:58:37 +0900
Message-ID: 
 <CAF3Gu1Zw+pDCqBzASHNbpPus5rS6iAWfXosZXkcu9eW-V+7XPQ@mail.gmail.com>
Subject: interval data type storage size
From: nuko yokohama <nuko.yokohama@gmail.com>
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=001a11c3a45278514004f61b6a83
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a11c3a45278514004f61b6a83
Content-Type: text/plain; charset=ISO-8859-1

Hi,

PostgreSQL 9.3 document in "Table 8-9" of "8.5. Date / Time Types", storage
 size of the interval data type has 12 bytes.
However, the definition of "datatype/timestamp.h", size of the interval
data type was 16 bytes.
In addition, interval data type was 16 bytes even dump the results of the
table file.
"day" field to the interval data type is added in PostgreSQL 8.1, but do
not not been reflected in the document PostgreSQL at that time?

Regards.

----
nuko yokohama

--001a11c3a45278514004f61b6a83
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>PostgreSQL 9.3 document =
in &quot;Table 8-9&quot; of &quot;8.5. Date / Time Types&quot;, storage =A0=
size of the interval data type has 12 bytes.=A0</div><div>However, the defi=
nition of &quot;datatype/timestamp.h&quot;, size of the interval data type =
was 16 bytes.=A0</div>
<div>In addition, interval data type was 16 bytes even dump the results of =
the table file.=A0</div><div>&quot;day&quot; field to the interval data typ=
e is added in PostgreSQL 8.1, but do not not been reflected in the document=
 PostgreSQL at that time?</div>
<div><br></div><div>Regards.</div><div><br></div><div>----</div><div>nuko y=
okohama</div></div>

--001a11c3a45278514004f61b6a83--