From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | pf(at)pfortin(dot)com |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Aren't regex_*() functions built-in? |
Date: | 2023-11-12 00:53:01 |
Message-ID: | a479d6c0-b7eb-46ab-bb82-fc23774556da@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pf | 2023-11-12 01:04:17 | Re: Aren't regex_*() functions built-in? |
Previous Message | Adrian Klaver | 2023-11-12 00:16:20 | Re: Aren't regex_*() functions built-in? |