size of interval type

Started by Kasahara Tatsuhitoabout 12 years ago3 messagesgeneral
Jump to latest
#1Kasahara Tatsuhito
kasahara.tatsuhito@gmail.com

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kasahara Tatsuhito (#1)
Re: size of interval type

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Kasahara Tatsuhito
kasahara.tatsuhito@gmail.com
In reply to: Tom Lane (#2)
Re: size of interval type

2014/04/03 23:53 "Tom Lane" <tgl@sss.pgh.pa.us>:

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.

I see.
Thank you for your reply and quick fix!

Best regards,