converter pgplsql funcion - Mailing list pgsql-general

From paulo matadr
Subject converter pgplsql funcion
Date
Msg-id 290775.75932.qm@web52511.mail.re2.yahoo.com
Whole thread Raw
Responses Re: converter pgplsql funcion  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: converter pgplsql funcion  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List 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: Top 10 - Celebridades - Música - Esportes

pgsql-general by date:

Previous
From: "Willy-Bas Loos"
Date:
Subject: Re: [pgsql-general] cant find postgres executable after initdb
Next
From: Christian Schröder
Date:
Subject: Re: inherit table and its data