Re: Problema con Funcion

On 4/16/05, Marco Aurelio Sotelo Figueroa <masotelof(at)yahoo(dot)com(dot)mx> wrote:
> Estoy usando la version 8.0
> y el mensage es ERROR: $8 is declared Constant
>
>

CREATE FUNCTION funcion_prueba(param int) RETURNS INT AS
$$
BEGIN
param:=4;

RETURN 1;
END;
$$
LANGUAGE 'plpgsql' STABLE CALLED ON NULL INPUT SECURITY INVOKER;

----

template1=# \c uescc
You are now connected to database "uescc".
uescc=# \i func.sql
DROP FUNCTION
CREATE FUNCTION
uescc=# select funcion_prueba(3);
ERROR: "$1" is declared CONSTANT
CONTEXT: compile of PL/pgSQL function "funcion_prueba" near line 2

atentamente,
Jaime Casanova