| Lists: | pgsql-docs |
|---|
| 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 |
| 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
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | nuko yokohama <nuko(dot)yokohama(at)gmail(dot)com> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: interval data type storage size |
| Date: | 2014-04-09 08:25:56 |
| Message-ID: | 20140409082556.GH8685@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
On Thu, Apr 3, 2014 at 12:58:37PM +0900, nuko yokohama wrote:
> 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?
The interval data type size will be properly documented in the next
minor release.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +