| From: | "Sven R(dot) Kunze" <srkunze(at)mail(dot)de> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ERROR: functions in index expression must be marked IMMUTABLE |
| Date: | 2017-03-01 13:36:15 |
| Message-ID: | d297e048-ac49-9bed-32e3-9dd4e65d0978@mail.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 28.02.2017 17:50, David G. Johnston wrote:
> That would seem to be it.
>
> cache_locale_time() at the top of DCH_to_char which is in the call
> stack of the shared parsing code for both to_date and to_timestamp.
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/utils/adt/formatting.c;h=e552c8d20b61a082049068d2f8d776e35fef1179;hb=HEAD#l2363
>
> 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.
>
> David J.
I don't know if this is the right way and list to ask for this:
But if this is acceptable, I would be willing to contribute a patch to
enable exactly this.
Regards,
Sven
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Winkless | 2017-03-01 13:40:34 | Re: ERROR: functions in index expression must be marked IMMUTABLE |
| Previous Message | Johann Spies | 2017-03-01 08:15:51 | Re: is (not) distinct from |