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