meteficha/postgresql-simple — comment on commit 5bd863ec9b43e4365e5b85ed21aeaf7d2b4bc385
File:  line 0
By lpsmith:

I understand what you are saying, but trust me in that this was correct. This code I imported from some modifications I made to pgsql-simple. The `UTCTime` doesn't store TZ info, but `parseTime` understands and convert the timezone appropriately. So if postgresql returns say, 12:00-04, this will get translated into 16:00 `UTCTime`.

As far as I can tell, `TimestampWithTimeZone` stores all timestamps in UTCTime, and translates outgoing timestamps to some timezone (based on the server and/or client). There is no more data associated with a TimestampWithTimeZone than there is with a plain old Timestamp, it's just that the backend handles conversions to/from strings differently. And last I dealt with this issue, I couldn't make heads or tails of the behavior of the Timestamp type; it made absolutely no sense to me.

So I'm not supporting plain Timestamps at the moment because I don't understand them.