public inbox for [email protected]
help / color / mirror / Atom feedinterval data type storage size
2+ messages / 2 participants
[nested] [flat]
* interval data type storage size
@ 2014-04-03 03:58 nuko yokohama <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: nuko yokohama @ 2014-04-03 03:58 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: interval data type storage size
@ 2014-04-09 08:25 Bruce Momjian <[email protected]>
parent: nuko yokohama <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2014-04-09 08:25 UTC (permalink / raw)
To: nuko yokohama <[email protected]>; +Cc: 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 <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-04-09 08:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-04-03 03:58 interval data type storage size nuko yokohama <[email protected]>
2014-04-09 08:25 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox