[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.