On 11/11/23 16:25, p...@pfortin.com 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.kla...@aklaver.com



Reply via email to