"Eric Vollnogel" 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 00:00:00' AS timestamp witho
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:
I
On Thu, Feb 11, 2010 at 11:45 PM, sourabh bansal
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5324
> Logged by: sourabh bansal
> Email address: sourabh.k.ban...@gmail.com
> PostgreSQL version: 8.4
> Operating system: windows XP SP2
> Description:
On Fri, Feb 12, 2010 at 5:04 AM, Alexey Klyukin wrote:
>
> On Feb 12, 2010, at 6:21 AM, Robert Haas wrote:
>
>> On Thu, Feb 11, 2010 at 10:47 PM, Robert Haas wrote:
>>> On Thu, Feb 11, 2010 at 3:12 PM, Alexey Klyukin
>>> wrote:
> I think this might be the same problem previously discussed h
On Feb 12, 2010, at 6:21 AM, Robert Haas wrote:
> On Thu, Feb 11, 2010 at 10:47 PM, Robert Haas wrote:
>> On Thu, Feb 11, 2010 at 3:12 PM, Alexey Klyukin
>> wrote:
I think this might be the same problem previously discussed here:
http://archives.postgresql.org/pgsql-bugs/2010-01/msg0
