Postgres Pro
Downloads
Home   >   mailing lists

timetz storage vs timestamptz - Mailing list pgsql-hackers

From Jim C. Nasby
Subject timetz storage vs timestamptz
Date
Msg-id 20061003213548.GY81937@nasby.net
Whole thread Raw
Responses Re: timetz storage vs timestamptz  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: scripts/common.c minor memory leak
Next
From: Zdenek Kotala
Date:
Subject: workaround for buggy strtod is not necessary