On Jan 25, 2008 10:19 AM, Gary Stainburn <gary.stainburn@ringways.co.uk> 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, textpg_catalog | regexp_replace | text | text, text, text, text
I think you lost a p in there.