interval data type storage size

From: nuko yokohama <nuko(dot)yokohama(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: interval data type storage size
Date: 2014-04-03 03:58:37
Message-ID: CAF3Gu1Zw+pDCqBzASHNbpPus5rS6iAWfXosZXkcu9eW-V+7XPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Amit Langote 2014-04-03 04:12:18 Re: Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL
Previous Message Tom Lane 2014-04-03 03:54:32 Re: Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL