On Thu, May 10, 2018 at 10:03 AM, Ben Hood <b...@relops.com> wrote: ... > Am I missing the point of how Postgres stores TIMEZONE WITH TIME ZONE > internally?
After reading in the follow up TIMEZONE is a typo for TIMESTAMP, yes, you are. Aproximately, postgres stores ( virtually ) a point in the time line, for both with and without ts types, same format. Something like a real number. The difference is mainly for transforming from/to text ( bear in mind when you put a constant in a query you are trasnforming from text ). In the with time zone case it formats/expects it as a time string in the session configured time zone, in the without case it treats it ( aproximately ) as if it was in utc ( and then discards the "+00" after formating ). Maybe I'm confussing you more, its not too easy to explain. The point is TIMEZONE is not stored in either of them. Francisco Olarte.
