size of interval type
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
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