Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE
Дата
Msg-id CAEzk6ffRRK+KkGwx6OUpSqkzRYcuya+Vr2UKzJcecvP+2EHpCw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: functions in index expression must be markedIMMUTABLE  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 28 February 2017 at 15:59, Adrian Klaver <adrian.klaver@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=e552c8d20b61a082049068d2f8d776e35fef1179;hb=HEAD

​Would the fact that you can have month names in to_date strings make it dependent on current locale?

​Geoff

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Querying JSON Lists
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE