Re: Aren't regex_*() functions built-in?

On 11/11/23 16:25, pf(at)pfortin(dot)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(dot)klaver(at)aklaver(dot)com