From: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | my first procedure |
Date: | 2006-08-10 19:21:40 |
Message-ID: | 20060810192140.24308.qmail@web32114.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
folks
i´ts is my first procedure/function
the pgadmin show 10 secs in execute it
any pointer be apreciated
CREATE OR REPLACE FUNCTION fs_getstring() RETURNS TEXT
AS '
DECLARE
DECLARE
curs1 CURSOR FOR select id_reparticion
::varchar || chr(1) || codigo_reparticion ::varchar
|| chr(1) ||
codigo_repar_inter ::varchar || chr(1) ||
nombre_reparticion ::varchar || chr(1) ||
vigencia_desde ::varchar
|| chr(1) || vigencia_hasta ::varchar || chr(1) ||
id_calle_repar ::varchar || chr(1) || numero ::varchar
|| chr(1) || piso ::varchar ||
chr(1) || oficina ::varchar || chr(1) || telefono
::varchar || chr(1) || fax ::varchar ||
chr(1) || email ::varchar || chr(1) ||
codigo_estructura ::varchar || chr(1) ||
repart_presentismo ::varchar || chr(1) ||
id_reparticion_ext ::varchar || chr(1) ||
proximo_remito ::varchar || chr(1) || en_red
::varchar || chr(1) ||
sector_mesa ::varchar || chr(255) ::text
from repartit;
v_buffer TEXT ;
v_var TEXT ;
BEGIN
v_var = '''' ;
open curs1 ;
FETCH curs1 INTO v_buffer ;
WHILE ( FOUND ) LOOP
v_var = v_var || v_buffer ;
FETCH curs1 INTO v_buffer ;
END LOOP;
close curs1 ;
RETURN v_var;
END
' LANGUAGE 'plpgsql';
the statement
v_var = v_var || v_buffer ;
allocate memory dynamically , i think this is problem
any clue?
best regards
MDC
__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas
From | Date | Subject | |
---|---|---|---|
Next Message | Brent Wood | 2006-08-10 20:38:42 | Re: How to do auto numbering on INT column |
Previous Message | Shoaib Mir | 2006-08-10 19:08:57 | Re: High available solution |