On Fri, Nov 21, 2008 at 7:37 AM, paulo matadr <[EMAIL PROTECTED]> wrote:
> 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:
See OraToPg:
You can download it here: http://pgfoundry.org/projects/ora2pg/
You ca
ta-feira, 21 de Novembro de 2008 13:02:36
Assunto: Re: [GENERAL] converter pgplsql funcion
2008/11/21 paulo matadr <[EMAIL PROTECTED]>:
> not working.. i try to explain my dought
> my idea is:
> 1- create a table for storage special caracters,
> create table caracteres
paulo matadr wrote:
>
> -- Executando consulta:
> create or replace function clean_string(_p_dado character varying)
^^^
clea[n]_string
> ** Erro **
>
> ERROR: function clear_string(character varying) does not exist
^^^
clea[r]
to add explicit type casts.
>
> ** Erro **
>
> ERROR: function clear_string(character varying) does not exist
> SQL state: 42883
> Dica: No function matches the given name and argument types. You may need to
> add explicit type casts.
> Caracter: 46
>
> any idea
her way to complete this ?
De: Pavel Stehule <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL
Enviadas: Sexta-feira, 21 de Novembro de 2008 10:05:02
Assunto: Re: [GENERAL] converter pgplsql funcion
Hello
create or replace function
Hello
create or replace function clean_string(_p_dado varchar)
returns varchar as $$
declare
_v_clean_string varchar := _p_dado;
_c varchar;
begin
for _c in select caracter from caracters loop
_v_clean_string := replace(_c_clean_string, _c);
end loop;
return _c;
end;
$$ language plpg
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 (sel