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 matches the given name and argument types. You may need to
add explicit type casts.
goole=#
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
