"Andreas Schultz" <[EMAIL PROTECTED]> writes:
> MST is UTC-07, so i would expect that i can replace MST with UTC-07, but:
> # SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME
> ZONE 'UTC-07';
> timezone
> ---------------------
> 2001-02-17 08:38:40
> The time returned is at UTC+07....
A time zone name in that form is a POSIX-spec timezone specification,
and the POSIX spec says that positive is west from Greenwich.
Everywhere else in Postgres we follow the SQL spec, which says that
positive is east from Greenwich. Aren't standards wonderful?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
