Re: size of interval type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kasahara Tatsuhito <kasahara(dot)tatsuhito(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: size of interval type
Date: 2014-04-03 14:53:51
Message-ID: 18515.1396536831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kasahara Tatsuhito <kasahara(dot)tatsuhito(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-04-03 14:59:19 Re: Any way to insert rows with ID used in another column
Previous Message Rob Sargent 2014-04-03 14:52:38 Re: COPY v. java performance comparison