| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Serge Fonville | 2008-11-14 16:34:35 | Re: [JDBC] Re : [pgadmin-support] trouble in installing postgreSQL 8.3 |
| Previous Message | Tom Lane | 2008-11-14 15:56:21 | Re: Delete cascade trigger runs security definer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sabin Coanda | 2008-11-14 16:27:44 | raise doesn't add end of line |
| Previous Message | Sabin Coanda | 2008-11-14 13:17:39 | Re: uuid on windows |