Result
-- Executando consulta:
create or replace function clean_string(_p_dado character varying)
returns character varying as $$
declare
_v_clean_string character varying := _p_dado;
_c character varying;
begin
for _c in select caracter from caracters loop
_v_clean_string := btrim(_c_c
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]
not working.. i try to explain my dought
my idea is:
1- create a table for storage special caracters,
create table caracteres(
caracter character varying
);
insert into caracteres values(':');
insert into caracteres values(';');
insert into caracteres values('<');
insert into caracteres values('=')
