On 11/11/23 16:25, pf@xxxxxxxxxxx wrote:
Reply to list also
Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
Probably because it is spelled regexp_replace ().
OK, found it in pg_catalog; but "create extension regexp_replace;" won't
load it. How do I get regexp_* into public schema?
Not sure why you are trying create extension regexp_replace;.
The functions are already loaded:
\df regexp_replace
List of functions
Schema | Name | Result data type | Argument
data types | Type
------------+----------------+------------------+------------------------------------------+------
pg_catalog | regexp_replace | text | text, text, text
| func
pg_catalog | regexp_replace | text | text, text, text,
integer | func
pg_catalog | regexp_replace | text | text, text, text,
integer, integer | func
pg_catalog | regexp_replace | text | text, text, text,
integer, integer, text | func
pg_catalog | regexp_replace | text | text, text, text,
text | func
Just just them:
select regexp_replace('Thomas', '.[mN]a.', 'M');
regexp_replace
----------------
ThM
Sorry if this a newbie question...
ncsbe=# \df "replace"
List of functions
Schema | Name | Result data type | Argument data types | Type
------------+---------+------------------+---------------------+------
pg_catalog | replace | text | text, text, text | func
(1 row)
ncsbe=# \df "regex"
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)
There are no regex* functions in /usr/share/postgresql/extension
Thanks,
Pierre
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
