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:
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