On 28.02.2017 17:50, David G. Johnston wrote:if this is acceptable, I would be willing to contribute a patch to enable exactly this.Supposedly one could provide a version of to_date that accepts a locale in which to interpret names in the input data - or extend the format string with some kind of "{locale=en_US}" syntax to avoid changing the function signature.
I don't see how that would help. You can't set a function to be immutable for "some" inputs (ie where locale is specified in the format string).
The only way to do it would be to add to_date(string, string, string) where the third string specifies the locale, at which point I don't really see why you would gain anything over creating your own UDF.
Geoff
