Postgres Pro
Downloads
Home   >   mailing lists

Re: timetz storage vs timestamptz - Mailing list pgsql-hackers

From Tom Lane
Subject Re: timetz storage vs timestamptz
Date
Msg-id 25163.1159914759@sss.pgh.pa.us
Whole thread Raw
In response to timetz storage vs timestamptz  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: timetz storage vs timestamptz  (Jim Nasby <jimn@enterprisedb.com>)
List pgsql-hackers
Tree view 
"Jim C. Nasby" <jim@nasby.net> writes:
> Why is it timestamptz can store a date and time to 1 microsecond in 8
> bytes but a timetz needs 12 to store just the time to 1 microsecond?

It's tracking the timezone explicitly ... something that timestamptz
really ought to do too.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: PG qsort vs. Solaris
Next
From: Jeremy Drake
Date:
Subject: buildfarm failures in ECPG-Check