Re: size of interval type - Mailing list pgsql-general

From Tom Lane
Subject Re: size of interval type
Date
Msg-id 18515.1396536831@sss.pgh.pa.us
Whole thread Raw
In response to size of interval type  (Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>)
Responses Re: size of interval type  (Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>)
List pgsql-general
Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com> writes:
> The document says the size of interval type is 12 bytes.
> http://www.postgresql.org/docs/9.3/static/datatype-datetime.html
> But ISTM the size is actually 16 bytes.
> # I checked src/include/datatype/timestamp.h and pg_type system view.

> Is it a document bug? Or am I missing something?

It's a documentation bug; the size used to be 12 bytes, but that was quite
a long time ago.  I see somebody fixed this in HEAD recently but failed to
back-patch it.

            regards, tom lane


pgsql-general by date:

Previous
From: Ben Hoyt
Date:
Subject: Any way to insert rows with ID used in another column
Next
From: Rob Sargent
Date:
Subject: Re: COPY v. java performance comparison