Postgres Pro
Downloads
Home   >   mailing lists

size of interval type - Mailing list pgsql-general

From Kasahara Tatsuhito
Subject size of interval type
Date
Msg-id CAP0=ZVKn26+A0CViMcCg3kMDKx1UATtCQhY2688JDHF_J-hRWg@mail.gmail.com
Whole thread Raw
Responses Re: size of interval type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Dorian Hoxha
Date:
Subject: Re: Pagination count strategies
Next
From: Ben Hoyt
Date:
Subject: Any way to insert rows with ID used in another column