Обсуждение: size of interval type

Поиск
Список
Период
Сортировка

size of interval type

От
Kasahara Tatsuhito
Дата:
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


Re: size of interval type

От
Tom Lane
Дата:
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


Re: size of interval type

От
Kasahara Tatsuhito
Дата:


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,