| From: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | converter pgplsql funcion |
| Date: | 2008-11-21 12:37:02 |
| Message-ID: | 290775.75932.qm@web52511.mail.re2.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I work with oracle and have poor experience in pg/plsql.
anybody can help me with translate from pl/sql in pg/plsql in code below:
CREATE OR REPLACE FUNCTION clean_string(p_dado varchar2) RETURN varchar2
IS
v_clean_string varchar(4000);
BEGIN
v_clean_string := p_dado;
for r in (select caracter from caracteres) loop
select replace(v_clean_string,r.caracter,'')
into v_clean_string
from dual;
end loop;
return v_clean_string;
END;
/
need funcion in pg/plsql
thanks for help
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ciprian Dorin Craciun | 2008-11-21 12:50:45 | Using Postgres to store high volume streams of sensor readings |
| Previous Message | Christian Schröder | 2008-11-21 12:14:37 | Re: inherit table and its data |