I think there is a bug in the PostgreSQL date system:
Try computing (replace XXXX with some differents years):
'XXXX-10-01'::datetime + '1 month'::interval
Depending on the year, you can get 'XXXX-11-01' as expected or 'XXXX-10-31'
which is bug.
Guillaume Perréal - Stagiaire MIAG
Cemagref (URH), Lyon, France
Tél: (+33) 126.96.36.199.64
pgsql-bugs by date
|Next:||From: Fabienne Leclere||Date: 2000-04-13 08:28:33|
|Subject: ECPGdo |
|Previous:||From: Peter Eisentraut||Date: 2000-04-13 02:04:47|
|Subject: Re: Re: [SQL] Foreign keys breaks tables permissions|