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

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

Responses

Browse pgsql-es-ayuda by date

  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