Thread: interval data type storage size
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
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@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +