Re: Date input changed in 7.4 ?

"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> Mendola Gaetano wrote:
> > Hi all,
> > I noticed that some date are not anymore accepted:
> >
> >
> > Postgres 7.3.3:
> >
> > test=# select '18/03/71'::date;
> > date
> > ------------
> > 1971-03-18
> > (1 row)
> >
> >
> > Postgres 7.4beta1:
> >
> > test=# select '18/03/71'::date;
> > ERROR: invalid input syntax for date: "18/03/71"
> >
> >
> > is this the indendeed behaviour ?
>
> Yes, we now honor datestyle to determine how to deal with dates where
> the year is at the end. You can set your date style to 'euopean' or the
> new 'DMY' value to allow this.
>
> This highlights the fact I need to get the compatibility section written
> for the history file soon.

May I also suggest to change in date.c the 3 generic error:

"invalid input syntax for date: "

with more comprensive messages ?

Regards
Gaetano Mendola