Re: interval data type storage size

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
Thread:
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. +

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Geoghegan 2014-04-09 08:40:39 Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)
Previous Message Heikki Linnakangas 2014-04-09 08:21:26 Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)