[BUGS] BUG #5325: Timestamp w/ timezone + interval not functioning correctly

2010-02-12 Thread Eric Vollnogel
The following bug has been logged online: Bug reference: 5325 Logged by: Eric Vollnogel Email address: edvollno...@dstsystems.com PostgreSQL version: 8.4.2 Operating system: Windows XP Description:Timestamp w/ timezone + interval not functioning correctly Details:

Re: [BUGS] BUG #5325: Timestamp w/ timezone + interval not functioning correctly

2010-02-12 Thread Tom Lane
Eric Vollnogel edvollno...@dstsystems.com writes: The output in this example is incorrect. Well, that's debatable. As you say, the result of the subtraction is interval -- 44 days 23:00:00 (1 row) If we add 44 days to timestamp1, we get select cast('2010-03-01