Re: [BUGS] BUG #3816: Timezone bug

2007-12-14 Thread Gregory Stark
"Geert Bijloos" <[EMAIL PROTECTED]> writes: > The following bug has been logged online: > PostgreSQL version: 8.1.3 and 8.2.4 > Description:Timezone bug Without actually checking whether the results are wrong I'll note that several of the changes in the bug-fix releases post 8.1.3 and 8.

Re: [BUGS] BUG #3816: Timezone bug

2007-12-14 Thread Tom Lane
"Geert Bijloos" <[EMAIL PROTECTED]> writes: > Try this > SET TIMEZONE TO 'CET'; > SELECT (timestamp with time zone '2000-01-01 UT' + interval '86 days 0 hours > 5 min 0 sec') at time zone 'UT'; > "2000-03-26 23:05:00" -> WRONG On what grounds do you claim that that's wrong?