Re: Date input changed in 7.4 ?

"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Mendola Gaetano" <mendola@bigfoot.com> writes:
> > I noticed that some date are not anymore accepted:
> > test=# select '18/03/71'::date;
> > ERROR:  invalid input syntax for date: "18/03/71"
> > is this the indendeed behaviour ?
> 
> If it does not match your DateStyle setting, then yes.
> 
> regression=# select '18/03/71'::date;
> ERROR:  invalid input syntax for date: "18/03/71"
> regression=# show DateStyle ;
>  DateStyle
> -----------
>  ISO, MDY
> (1 row)
> 
> regression=# set datestyle = dmy;
> SET
> regression=# select '18/03/71'::date;
>     date
> ------------
>  1971-03-18
> (1 row)

Great.

How I already suggest to Bruce I think is better give an hint
on the error reported just to avoid to be overloaded of 
emails like mine.

My cent.


Regards
Gaetano Mendola