Re: Date input changed in 7.4 ?

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073