Re: BUG #5552: incorrect returned value of time

"Konstantin Kulikov" <k(dot)e(dot)kulikov(at)gmail(dot)com> writes:
> Description: incorrect returned value of time

> select current_timestamp at time zone 'GMT+3';

> will return actually 'GMT-3'

This is unfortunate, but it's not a bug. There are two different
standards about the sign of timezone offsets, and Postgres has to
deal with both of them. See
http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES
particularly the note that

Another issue to keep in mind is that in POSIX time zone names,
positive offsets are used for locations west of
Greenwich. Everywhere else, PostgreSQL follows the ISO-8601
convention that positive timezone offsets are east of Greenwich.

regards, tom lane