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

[HACKERS] timetz storage vs timestamptz

2006-10-03 Thread Jim C. Nasby
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? -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

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.