Bug in Time/Date routines

Hi Folks !

I just found a bug in the postgresql time/date routines.

Try the following in the psql shell :

select ('10-01-2000'::date + ('1 month')::timespan)::date;

The result is going to be

10-31-2000

But it should be

11-01-2000

If you take any other month than October, it is working fine. So 09-01-2000 + 1 month => 10-01-2000.

I've tested this with postgresql 6.5.3 as well as 7.0.2

Thanks for the good work....

Moritz

P.S. what about a way to cancel a query that is waiting for a locked table / row ?