more timeofday() and "set time zone" weirdness - Mailing list pgsql-general

I posted earlier with a very complex example.  This simple one
gets to the point much faster.  timeofday() seems to behave
inconsistently when the timezone is set with "GMT+X" notation.

foo=> select cast(timeofday() as timestamp with time zone); set time
zone 'GMT+4'; select cast(timeofday() as timestamp with time zone);
           timeofday
-------------------------------
 2003-08-13 11:01:26.502064-04
(1 row)

SET VARIABLE
           timeofday
-------------------------------
 2003-08-13 07:01:26.503328-04
(1 row)


I am currently 4 hours behind GMT.  The first timestamp reflects
the correct time.  After setting the time zone to "GMT+4", I get
a time value that is 4 hours too early.  If I were to instead
use "America/New_York" for the time zone, I would not have this
problem.  Unfortunately, I cannot use such notation under Cygwin.
BTW -- I am seeing this problem with version 7.2.3 under RH Linux
version 7.3.

Jason Priebe
jason_priebe@yahoo.com