Hi folks.
I've got a problem with regex_replace. As you can see below psql displays the
error saying the function does not exist. Can anyone see why, and what I
need todo to fix it.
Cheers
goole=# select distinct ud_rfl from used_diary where ud_rfl ~ ' *= *';
ud_rfl
---
12 = 1wk
Gary Stainburn wrote:
Hi folks.
I've got a problem with regex_replace.
The function is regexp_replace - you misspelled it.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Sorry,
should have added that I tried type-casting to see if that fixed it. It
didn't.
Gary
goole=# select distinct regex_replace(ud_rfl::text,' *= *'::text,'+'::text)
from used_diary where ud_rfl ~ ' *= *';
ERROR: function regex_replace(text, text, text) does not exist
HINT: No function ma
On Jan 25, 2008 10:19 AM, Gary Stainburn <[EMAIL PROTECTED]> wrote:
> Sorry,
>
> should have added that I tried type-casting to see if that fixed it. It
> didn't.
>
> Gary
>
> goole=# select distinct regex_replace(ud_rfl::text,' *= *'::text,'+'::text)
\df regexp*
List