Michael Glaesemann <grzm@seespotcode.net> wrote:
>> IMVHO best practice is to treat TIMESTAMP WITH TIME ZONE
>> as truly evil (TM),
> Um, why?
Because its in- and output depend on:
- The time zone set in the server's OS configuration,
- the time zone set in the server's PostgreSQL configura-
tion,
- the time zone set in the user's configuration,
- a possible "SET SESSION" command,
- a possible "SET LOCAL" command and
- a possible "AT TIME ZONE" construct.
Add to that the possibility that the zoneinfo data might
differ from server to server and over time.
So unless you are /very/ certain that all servers, all us-
ers and all clients will use the same settings always and
forever, especially if clients exchange data outside the da-
tabase, I'd recommend avoiding "WITH TIME ZONE" whenever
possible.
Tim
