interval data type storage size
interval data type storage size
От:
nuko yokohama <nuko.yokohama@gmail.com>
Дата:
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
Re: interval data type storage size
От:
Bruce Momjian <bruce@momjian.us>
Дата:
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 http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +