Riddle me this... I have a field of type timestamp. I do 3 queries on a particular record one is AT TIME ZONE 'UTC', ones is AT TIME ZONE Australia/Sydney, one is plain, without a clause and I get:
We are no longer in bug reporting territory. Depesz wrote a good article on all this a while back. I’d suggest reading it then following up further on the -general mailing list if you still have questions.