From: | sandrigo lezcano <alkafes(at)yahoo(dot)com> |
---|---|
To: | pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx |
Subject: | [Pgsql-ayuda] returns setof ... ERROR!!! |
Date: | 2003-09-30 20:42:29 |
Message-ID: | 20030930204229.57474.qmail@web20006.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hector Choque Reyes | 2003-09-30 20:47:17 | [Pgsql-ayuda] Coneccion PostgreSQL con Windows |
Previous Message | Alvaro Herrera | 2003-09-30 20:02:35 | Re: [Pgsql-ayuda] Evento de la base de datos |