BUG #1871: operations with data types - Mailing list pgsql-bugs

From
Subject BUG #1871: operations with data types
Date
Msg-id 20050909120031.9B887F0BAF@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1871: operations with data types
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1871
Logged by:
Email address:      anris@polynet.lviv.ua
PostgreSQL version: 7-8
Operating system:   Linux
Description:        operations with data types
Details:

May be it is not bug, but anywhere:

here you are sample query
select '2005-08-31'::date + '1 month'::interval-'1 month'::interval

from the mathematical me the resulting value should be '2005-08-31', but
......

can you explain this

pgsql-bugs by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Race-condition with failed block-write?
Next
From: "Hugo Cesar"
Date:
Subject: BUG #1872: Failed to create process: 2!