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
lect count(id) from test;
You'll get
ERROR: ExecEvalAggref: no aggregates in this expression context
This is in PSQL 7.1beta4. The latest from your CVS directory.
Thanks for fixing.
Moritz Gmelin
begin:vcard
n:Gmelin;Moritz
tel;fax:0721/9654753
tel;home:0721/9431335
tel;work:0721/96
