Skip site navigation (1) Skip section navigation (2)

Enc: Help to replace caracter

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: GENERAL <pgsql-general(at)postgresql(dot)org>, Sql-listas_post <pgsql-sql(at)postgresql(dot)org>
Subject: Enc: Help to replace caracter
Date: 2008-11-14 16:17:04
Message-ID: 343243.4907.qm@web52503.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql




I Need to replace string (" ) in the situation below :
 
select  clie_nmcliente    from cadastro.cliente where clie_nmcliente like '%"%'; 
 
result:
JOANA D"ARCALMEIDA"
EMLURB "P M R."
CECILIA D"CAGNO"
HELENA FERREIRA D"FREITAS"
JOSE M. "BARRACA DO BOLA"
FORTE" DUNAS BAR"
JOANA D"ARC R. DE SOUZA
ASSEMBLEIA DE DEUS"
USINA SALGADO"SUPRIMENTO 
JOSE MOURA  'BIGODE"
BEATRIZ MEDEIROS D"EMERY

Any help me to create pgPL/sql or funcion  to replace ( " )  to null value, I have many table with this.
Thanks for help



      Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Responses

pgsql-sql by date

Next:From: Sabin CoandaDate: 2008-11-14 16:27:44
Subject: raise doesn't add end of line
Previous:From: Sabin CoandaDate: 2008-11-14 13:17:39
Subject: Re: uuid on windows

pgsql-general by date

Next:From: Serge FonvilleDate: 2008-11-14 16:34:35
Subject: Re: [JDBC] Re : [pgadmin-support] trouble in installing postgreSQL 8.3
Previous:From: Tom LaneDate: 2008-11-14 15:56:21
Subject: Re: Delete cascade trigger runs security definer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group