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

On Thu, Apr 3, 2014 at 08:46:28AM +0000, nuko.yokohama@gmail.com wrote:

The following bug has been logged on the website:

Bug reference: 9843
Logged by: nuko yokohama
Email address: nuko.yokohama@gmail.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.

This will be fixed in 9.4 with this patch:

commit 146604ec43bcd6f977c31775a91022cf9737daf5
Author: Bruce Momjian <bruce@momjian.us>
Date: Thu Jan 30 09:41:43 2014 -0500

Add checks for interval overflow/underflow

New checks include input, month/day/time internal adjustments, addition,
subtraction, multiplication, and negation. Also adjust docs to
correctly specify interval size in bytes.

Report from Rok Kralj

I am not sure why this was not fixed earlier.

"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?

Uh, can you show me a sentence where it is missing? I don't see it.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs