workaround for lack of REPLACE() function - Mailing list pgsql-general

From Agent155 Support
Subject workaround for lack of REPLACE() function
Date
Msg-id 00de01c2285d$425f5a10$6601a8c0@home
Whole thread Raw
Responses Re: workaround for lack of REPLACE() function
List pgsql-general
Hi,
 
I looked around for a definitive answer to this question but to no avail.  It appears that PostgreSQL does not implement the SQL function REPLACE() , which, in MySQL works like this:
 
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str replaced by the string to_str:
 
What do folks usually do when they have to do a global search/replace on a big table?
 
Thanks,
 
Matt

pgsql-general by date:

Previous
From: Mark O'Connor
Date:
Subject: Re: XML to Postgres conversion
Next
From: sarah.fraser@cnet.com (builder)
Date:
Subject: MySQL vs. PostgreSQL