[Pgsql-ayuda] Problema con funciones

[Adrian Galindo]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
Fernando Papa wrote:

>cstring? por que no usas varchar?
> =20
>
Versi=F3n con varchar:


ssa=3D>  CREATE FUNCTION quitaacentos (varchar) RETURNS varchar AS
ssa->   'select=20
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(R=
EPLACE(
ssa'>    REPLACE(cadena, \'=E1\', \'a\'), \'=C1\', \'A\'),\'=E9\',\'e\'),=
=20
\'=C9\',\'E\'), \'=CD\', \'I\'),\'=ED\',\'i\'),
ssa'>     \'=D3\', \'O\'),\'=F3\',\'o\'),\'=DA\',=20
\'U\'),\'=FA\',\'u\'),\'=F1\',\'n\')'
ssa->      LANGUAGE 'plpgsql';
CREATE FUNCTION
ssa=3D> select quitaacentos('Alg=F3 co=F1 =E1ce=F1t=F3s');
WARNING:  plpgsql: ERROR during compile of quitaacentos near line 1
ERROR:  parse error at or near "select"


=BFAlguna otra idea?

Saludos.
Adri=E1n.