Re: Timestamp/Timezone - does this make sense?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/14/07 01:42, Tom Lane wrote:
> Mike Harding <mharding(at)edentreetech(dot)com> writes:
>> Where does that extra 8 hours come from?
>
> Ellay is 8 hours west of UTC (at least on 1-Jan, at least till our
> congresscritters see fit to monkey with the DST laws again). What
> problem have you got with these answers? They look right to me.

I think he's asking why:
select timestamp with time zone '2007-01-01'
at time zone 'America/Los_Angeles';
---------------------
2006-12-31 16:00:00

returns a different value than
select timestamp '2007-01-01'
at time zone 'America/Los_Angeles';
------------------------
2007-01-01 08:00:00+00
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF0sNSS9HxQb37XmcRAuFXAJ0Z82uaW7FKKAuCnYbrm/bh8MAyCgCfWUW5
2blMHVkmjhYEjsGzk0o+ybM=
=GbW7
-----END PGP SIGNATURE-----