[GENERAL] my first procedure

[marcelo Cortez]

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly