| 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: | Whole Thread | Raw Message | 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>
| 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 |