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
> [EMAIL PROTECTED] | (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 [EMAIL PROTECTED])
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (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 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly