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 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() ? > > In reality, we are trying to change characters like the 1/2 character to > the three characters '1/2'. > > Thanks for any assistance. > > > -- > Until later, Geoffrey > > "I predict future happiness for America if they can prevent > the government from wasting the labors of the people under > the pretense of taking care of them." > - Thomas Jefferson > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
