From: | Eagna <eagna(at)protonmail(dot)com> |
---|---|
To: | Gianni Ceccarelli <dakkar(at)thenautilus(dot)net> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Regular expression to UPPER() a lower case string |
Date: | 2022-12-10 14:36:04 |
Message-ID: | no-TAHXqJChgnBd7ktUt7mgS_bXjtckgoWF12PUsaO-OoBcCT1m_a5PHqbkvX3pM1VX1tYE1-N2obvLDoA5S7WZvi9FU0JdIvlbAEgAmZm8=@protonmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> `select upper(x) from test`
I know about the UPPER() and LOWER() functions - I don't want them!
> If you want to do something else, please describe the actual thing you
> want to do. Not "how", but "what".
I have described it - I want to do the *_same_* thing as UPPER() does using REGEXP_REPLACE().
In the duplicate thread (apologies to the list for that - my bad!), I wrote:
====================
> I want to index on a REGEXP_REPLACE() - I thought using lower -> upper would be a good test.
> I could always have used another REGEXP_REPLACE() for my testing, but I then became "obsessed" with the idea of using REGEXP_REPLACE() as a substitute for UPPER() - kind of an obfuscated code competition with myself! :-)
========================
So, I have no actual *_need_* for this, other than a desire to learn and understand what's going on and why.
> Maybe you need to look at `regexp_split_to_array` or
> `regexp_split_to_table`?
I'm pretty sure that I have a good understanding of these. I thought I understood REGEXP_REPLACE(), but obviously not.
Thanks for any further input.
E.
> Dakkar - <Mobilis in mobile>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2022-12-10 14:48:58 | Re: Regular expression to UPPER() a lower case string |
Previous Message | Peter J. Holzer | 2022-12-10 14:08:43 | Re: Regular expression to UPPER() a lower case string |