Re: regex_replace problem -additional - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: regex_replace problem -additional
Date
Msg-id 200801251619.43305.gary.stainburn@ringways.co.uk
Whole thread Raw
In response to regex_replace problem  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Responses Re: regex_replace problem -additional  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
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     


pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Unclosed connections
Next
From: "Scott Marlowe"
Date:
Subject: Re: This SQL works under Mysql, not Postgresql.