Обсуждение: interval data type storage size

Поиск
Список
Период
Сортировка

interval data type storage size

От
nuko yokohama
Дата:
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
Дата:
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. +