Re: proper regex_replace() syntax

On Wed, Jun 1, 2011 at 10:22 AM, Geoffrey Myers <lists(at)serioustechnology(dot)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 more then one row.
>
> So, is there a way to do what I'm trying to do? That is, replace the same
> character in multiple records using regex_replace() ?
>

I think what you want is:

SELECT regex_replace(fname, 'z', 'Z') FROM table;

This should return a recordset where each row has one column which is the
result of regex_replace() on the corresponding row of table.
--
Rick Genter
rick(dot)genter(at)gmail(dot)com