Re: ERROR: functions in index expression must be marked IMMUTABLE

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "Sven R(dot) Kunze" <srkunze(at)mail(dot)de>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: functions in index expression must be marked IMMUTABLE
Date: 2017-02-28 16:35:56
Message-ID: CAEzk6ffRRK+KkGwx6OUpSqkzRYcuya+Vr2UKzJcecvP+2EHpCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 28 February 2017 at 15:59, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-02-28 16:50:19 Re: ERROR: functions in index expression must be marked IMMUTABLE
Previous Message Adrian Klaver 2017-02-28 16:33:17 Re: Querying JSON Lists