-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Tom Lane wrote: | Stuart Bishop <[EMAIL PROTECTED]> writes: | |>How much overhead is there in storing a timestamp with timezone as |>opposed to one without? | | | Exactly zero. You have a misconception about what the datatype really | does --- see other responses in this thread.
Indeed - I was under the impression that the timezone would be preserved (which is the case in the external datetime libraries I use), but I now see that PostgreSQL will lose this information.
- -- Stuart Bishop <[EMAIL PROTECTED]> http://www.stuartbishop.net/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFBb05DAfqZj7rGN0oRAnz3AJwLqPBMY1MNxjeXjg/orFWNI4+MrwCfSTyG wSZ0Hmo6Bg9y6ZgfItJOf3w= =xSUI -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
