From: | Geoff Winkless <pgsqladmin(at)geoff(dot)dj> |
---|---|
To: | "Sven R(dot) Kunze" <srkunze(at)mail(dot)de> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Geoff Winkless <pgsqladmin(at)geoff(dot)dj>, 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:40:34 |
Message-ID: | CAEzk6fdkO_j2t_rY=VVHCP+Q0nyG-tfDuAPjF10=8ukRgxpB-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1 March 2017 at 13:36, Sven R. Kunze <srkunze(at)mail(dot)de> wrote:
> On 28.02.2017 17:50, David G. Johnston wrote:
>
> 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.
>
> if this is acceptable, I would be willing to contribute a patch to enable
> exactly this.
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sven R. Kunze | 2017-03-01 14:23:25 | Re: ERROR: functions in index expression must be marked IMMUTABLE |
Previous Message | Sven R. Kunze | 2017-03-01 13:36:15 | Re: ERROR: functions in index expression must be marked IMMUTABLE |