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 of functions
Schema | Name | Result data type | Argument data types
------------+----------------+------------------+------------------------
pg_catalog | regexp_replace | text | text, text, text
pg_catalog | regexp_replace | text | text, text, text, text
I think you lost a p in there.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly