On 10/6/14, 6:19 PM, Jim Nasby wrote:
> FWIW, I agree for timestamptz, but I do wish we had a timestamp datatype that stored the exact timezone in effect
whenthe data was entered. That can really, REALLY save your rear if you screw up either timezone in postgresql.conf, or
theserver's timezone. The part that seems hard (at least to me) is the question of how to actually store the timezone,
becauseI don't think storing the text string "America/Central" is going to cut it. :/
For the archives... there's an extension that does what I'd been talking about: http://pgxn.org/dist/timestampandtz/.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com