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
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