[Pgsql-ayuda] returns setof ... ERROR!!!

[sandrigo lezcano]

q puede estar mal ???
en language 'sql' funciona!!!
pero con 'plpgsql'  NO..!!

dbtests=# select * from t3;
 num | valor | ref_t2
-----+-------+--------
   1 | ppp x |      1
   2 | qqq z |      5
   3 | rrr ? |      7
(3 rows)

dbtests=# create or replace function funcion_blabla() 
dbtests=# returns setof t3 as '
dbtests'# declare
dbtests'#      v_rec RECORD;
dbtests'# begin
dbtests'#     create temporary table blabla(num integer,
dbtests=#                  valor varchar(10),ref_t2 integer);
dbtests'#     FOR v_rec IN select * from t3 LOOP
dbtests'#         insert into blabla(num,valor,ref_t2) 
dbtests=#               values(v_rec.num,v_rec.valor,v_rec.ref_t2);
dbtests'#         IF NOT FOUND THEN
dbtests'#            RAISE NOTICE ''ERROR!!!  '';
dbtests'#         END IF;
dbtests'#         RAISE NOTICE ''Insertando % - % -% '',
dbtests=#               v_rec.num,v_rec.valor,v_rec.ref_t2;
dbtests'#     END LOOP;
dbtests'#     return blabla;
dbtests'# end;
dbtests'# ' language 'plpgsql';
CREATE FUNCTION
dbtests=# select * from funcion_blabla();
NOTICE:  Insertando 1 - ppp x -1
NOTICE:  Insertando 2 - qqq z -5
NOTICE:  Insertando 3 - rrr ? -7
 num | valor | ref_t2
-----+-------+--------
(0 rows)

dbtests=#


=====
--                             ICQ Web-based!!
----------------------------------------------
Sandrigo Lezcano Jara           ICQ: 143590717
Asuncion, Paraguay           http://go.icq.com

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com