From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Regular expression to UPPER() a lower case string |
Date: | 2022-12-10 13:13:46 |
Message-ID: | 20221210131346.3pqmksqk4jvnyxrm@hjp.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2022-12-10 10:41:41 +0000, Gianni Ceccarelli wrote:
> On 2022-12-10 Eagna <eagna(at)protonmail(dot)com> wrote:
> > This should be very (very) easy - I don't know what I'm missing -
> > I've done quite complex regular expressions before and I don't know
> > what I'm doing wrong. Brain burping this morning!
>
> You're missing that:
>
> * `regexp_replace` doesn't work like that, at all
No it doesn't. But the equivalent operation in some other languages and
tools does, so there is no reason that it couldn't do that (of course
neither is that a reason why it should).
> * your logic only works by accident for some languages (try to upcase
> a `ß` or a `ı`)
This is also true of upper() and lower() and SQL does provide those.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2022-12-10 13:31:50 | Re: Regular expression for lower case to upper case. |
Previous Message | Gianni Ceccarelli | 2022-12-10 12:06:54 | Re: Regular expression to UPPER() a lower case string |