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