Skip site navigation (1) Skip section navigation (2)

Re: Ayuda con variables de funciones

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: gabriela lópez <gabydhi(at)hotmail(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Ayuda con variables de funciones
Date: 2005-07-28 23:45:26
Message-ID: 20050728234526.GG6807@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
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."

In response to

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2005-07-28 23:47:21
Subject: Re: DoS al hacer un sub select
Previous:From: tania gutierrezDate: 2005-07-28 23:43:45
Subject: Re: problemas en postgresql -- ayuda !!!!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group