Re: Res: converter pgplsql funcion

From: Richard Huxton <dev(at)archonet(dot)com>
To: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Res: converter pgplsql funcion
Date: 2008-11-21 16:35:55
Message-ID: 4926E36B.4020808@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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]_string

> 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 for help ou give another way to complete this ?

Bus see what Pavel said about this being a slow way of doing it.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-21 16:39:28 Re: Prepared statement already exists
Previous Message Daniel Verite 2008-11-21 16:35:54 Re: Prepared statement already exists