size of interval type

From: Kasahara Tatsuhito <kasahara(dot)tatsuhito(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: size of interval type
Date: 2014-04-03 14:33:05
Message-ID: CAP0=ZVKn26+A0CViMcCg3kMDKx1UATtCQhY2688JDHF_J-hRWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

Best regards,

--
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Hoyt 2014-04-03 14:41:56 Any way to insert rows with ID used in another column
Previous Message Alban Hertroys 2014-04-03 14:01:46 Re: Pagination count strategies