On 28 February 2017 at 15:59, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 02/28/2017 07:30 AM, Sven R. Kunze wrote: > >> On 28.02.2017 15:40, Adrian Klaver wrote: >> >>> [explanation of why date casting and to_datetime don't work] >>> >> >> Why is to_date not immutable? >> > > Not sure, but if I where to hazard a guess, from the source code in > formatting.c: > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob; > f=src/backend/utils/adt/formatting.c;h=e552c8d20b61a08204906 > 8d2f8d776e35fef1179;hb=HEAD > > Would the fact that you can have month names in to_date strings make it dependent on current locale? Geoff