Re: Date input changed in 7.4 ? - Mailing list pgsql-hackers

"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)

        regards, tom lane