Tom Lane wrote: > "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.
Umm...I hope this is controllable with a GUC variable then. There are some cases where it's extremely useful for PostgreSQL to accept dates of any format it knows about (ambiguities should be resolved either by looking at the current DateStyle or, failing that, by applying the recognition in a well-defined order). In my case I can probably code around it but it does require some extra effort. But I can easily imagine situations in which that wouldn't be an option. Whatever happened to "be liberal in what you accept and conservative in what you send"? :-) -- Kevin Brown [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
