workaround for lack of REPLACE() function

From: "Agent155 Support" <matt(at)planetnet(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: workaround for lack of REPLACE() function
Date: 2002-07-10 22:00:03
Message-ID: 00de01c2285d$425f5a10$6601a8c0@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2002-07-10 22:08:51 Re: (A) native Windows port
Previous Message Roderick A. Anderson 2002-07-10 21:59:38 Re: MySQL password function

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2002-07-10 22:08:51 Re: (A) native Windows port
Previous Message Andrew Sullivan 2002-07-10 21:43:08 Re: powered by

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-07-10 22:50:11 Re: implementing query timeout
Previous Message Peter Eisentraut 2002-07-10 21:56:25 Re: install-sh patch for Mac OS X