"Mendola Gaetano" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
