Re: confucion con pgsql functions

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: confucion con pgsql functions
Date: 2007-12-18 21:53:03
Message-ID: 20071218215303.GF8088@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

marcelo Cortez escribió:

> CREATE OR REPLACE FUNCTION loadall2()
> RETURNS void AS
> $BODY$
> DECLARE b_1 character varying(60) ;
> declare b_2 character(200) ;
> declare b_3 boolean;
> BEGIN
> insert into t1( c1,c2,c3) values( b_1,b_2,b_3) ;
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE
>
> parecen no funcionar ( no me compila)

Works for me. ¿Que error te da?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Erick Urias 2007-12-19 01:53:57 Actualizar de 8.1 a 8.2.5
Previous Message Alejandro D. Burne 2007-12-18 21:42:48 Re: Hallar franja horaria