BUG #9843: interval data type storage size (8.1 later)

From: nuko(dot)yokohama(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9843: interval data type storage size (8.1 later)
Date: 2014-04-03 08:46:28
Message-ID: 20140403084628.309.87073@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9843
Logged by: nuko yokohama
Email address: nuko(dot)yokohama(at)gmail(dot)com
PostgreSQL version: 9.3.4
Operating system: CentOS 6.3
Description:

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 <nuko(dot)yokohama(at)gmail(dot)com>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2014-04-03 10:43:30 Re: Configuring Standby Server in PostgreSQL 9.3.3
Previous Message kurasanthoshkumar 2014-04-03 08:09:11 BUG #9841: Need some help in sql query