Why is time with timezone 12 bytes?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Why is time with timezone 12 bytes?
Date: 2010-09-22 21:01:47
Message-ID: 4C9A6EBB.7050307@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

All,

I was just checking on our year-2027 compliance, and happened to notice
that time with time zone takes up 12 bytes. This seems peculiar, given
that timestamp with time zone is only 8 bytes, and at my count we only
need 5 for the time with microsecond precision. What's up with that?

Also, what is the real range of our 8-byte *integer* timestamp?

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2010-09-22 21:02:18 Re: Another Modest Proposal: Platforms
Previous Message David Fetter 2010-09-22 20:58:05 Re: Another Modest Proposal: Platforms