timestamp cast to abstime problem

I figured this all out; turns out they were related.

I had set my timezone in the postmaster to Poland long ago and forgot,
and that is why both the abstime and show timezone produced strange
results. Sorry.

---------------------------------------------------------------------------

Bruce Momjian wrote:

Does anyone know why this returns 0 and not 3600?

test=> select '1970-01-01 01:00:00'::timestamp::abstime::int4;
int4
------
0
(1 row)

My time(2) manual page says:

The time() function returns the value of time in seconds since 0
hours, 0 minutes, 0 seconds, January 1, 1970, Coordinated Universal Time.

Also, why does my TimeZone show as Poland?

test=> SHOW TimeZone;
TimeZone
----------
Poland
(1 row)

-- 
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 359-1001
+  If your life is a hard drive,     |  13 Roberts Road
+  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073