Jaromír Talíř <jaromir(dot)talir(at)nic(dot)cz> writes:
> postgres# select '2008-06-01 10:10:10 UTC' AT TIME ZONE 'CET';
> timezone
> ---------------------
> 2008-06-01 12:10:10
ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.
If you want a timezone which switches between CET and CST automatically you
should use something like Europe/Paris.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!