[Pgsql-ayuda] Problema con funciones
Adrian Galindo
agalindo@liceaga.facmed.unam.mx
Thu, 19 Jun 2003 11:36:16 -0500
Fernando Papa wrote:
>Pero a ese plpgsql le falta algo:
> =20
>
Fernando, gracias por la ayuda. Pude avanzar un poco con esta parte.
-------------------------------
bd=3D> CREATE FUNCTION quita(varchar) RETURNS varchar AS
bd-> 'DECLARE cadena alias for $1;
bd'> begin
bd'> select=20
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(R=
EPLACE(
bd'> REPLACE($1, ''=E1'', ''a''), ''=C1'', ''A''),''=E9'',''e''),=20
''=C9'',''E''), ''=CD'', ''I''),''=ED'',''i''),
bd'> ''=D3'', ''O''),''=F3'',''o''),''=DA'', ''U''),''=FA'',''u''),''=
=F1'',''n'');
bd'> end'
bd-> LANGUAGE 'plpgsql';
CREATE FUNCTION
bd=3D> select quita('=E1=E9=ED=F1=F1');
WARNING: Error occurred while executing PL/pgSQL function quita
WARNING: line 3 at SQL statement
ERROR: SELECT query has no destination for result data.
If you want to discard the results, use PERFORM instead.
-------------------------
Sin embargo al querer usar el PERFORM:
bd=3D> PERFORM quita('=E1=E9=ED=F1=F1');
ERROR: parser: parse error at or near "PERFORM" at character 1
=BFAlguna idea?
Gracias de antemano.
Saludos.
Adri=E1n.