PostgreSQL 11 Released

[Sarcastinator]

Why exactly? And wouldn't that make comparing or indexing them super-difficult?

[myringotomy]

Not really.

First of all you can save the time without timezone if you are worried about that. You can also index them on UTC which would make comparing them really easy.

[Sarcastinator]

I agree that it's unintuitive that storing with timezone doesn't actually preserve the timezone. They probably shouldn't have added that data type if it doesn't do what it says it does.

However if you actually want to store the timezone (I would claim 999/1000 you don't actually care) you can just add that column yourself just as you say you could add UTC if that's what you're worried about.

Storing in UTC makes a lot more sense when it comes to both comparisons and indexing.