The following bug has been logged online:
Bug reference: 1871
Logged by:
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
