I want to use regex_replace() to replace characters in multiple records.
What I would like to do is this:
select regex_replace((select fname from table), 'z', 'Z'));
The problem is, the subquery returns more then one row.
So, is there a way to do what I'm trying to do? That is, replace the
I think this is the syntax you want:
SELECT regexp_replace(fname,'z','Z') FROM table;
On Wed, Jun 1, 2011 at 10:22 AM, Geoffrey Myers li...@serioustechnology.com
wrote:
I want to use regex_replace() to replace characters in multiple records.
What I would like to do is this:
select
On Wed, Jun 1, 2011 at 10:22 AM, Geoffrey Myers li...@serioustechnology.com
wrote:
I want to use regex_replace() to replace characters in multiple records.
What I would like to do is this:
select regex_replace((select fname from table), 'z', 'Z'));
The problem is, the subquery returns