Re: [HACKERS] timetz storage vs timestamptz

2006-10-05 Thread Jim Nasby
On Oct 3, 2006, at 5:32 PM, Tom Lane wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> 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

Re: [HACKERS] timetz storage vs timestamptz

2006-10-03 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> 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.