Re: Ayuda con variables de funciones

On Thu, Jul 28, 2005 at 11:05:37PM +0000, gabriela lópez wrote:

> CREATE OR REPLACE FUNCTION sp_nuevoinicio(varchar, varchar)
> RETURNS void AS
> $BODY$CREATE USER $1 PASSWORD ' $2 '
> CREATEDB CREATEUSER
> VALID UNTIL 'infinity';
> ALTER GROUP "AW" ADD USER $1;$BODY$
> LANGUAGE 'sql' VOLATILE;
>
> Marca error por los pesitos.

Que version del servidor estas usando?

select version();

Los $body$ estan soportados solo de 8.0 en adelante.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."