Peter Eisentraut wrote: > Tom Lane writes: > > > Other than me, I think you mean. dd/mm/yyyy and mm/dd/yyyy are > > inherently ambiguous in the real world, and when you can clearly > > determine what the intended meaning is, I think it's more reasonable > > to assume the datestyle isn't set correctly than to reject the data. > > That might even make the slightest sense if the supposedly wrong datestyle > would then stay switched. But the automatic switching only happens for a > certain subsets of inputs and only in that instance. So if a user did > really mean the opposite setting he will not be happy, and if the user did > not mean the opposite setting he will not be happy either. So no one is > happy.
I think we have had enough discussion to remove the question mark from this TODO item: * Allow current datestyle to restrict dates; prevent month/day swapping from making invalid dates valid Of course, if later discussion changes, I will re-add it. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
