Returning Rows in Procedure
| От | Adarsh Sharma |
|---|---|
| Тема | Returning Rows in Procedure |
| Дата | |
| Msg-id | 4DDB6787.3060807@orkash.com обсуждение исходный текст |
| Ответы |
Re: Returning Rows in Procedure
Re: Returning Rows in Procedure Re: Returning Rows in Procedure |
| Список | pgsql-general |
Dear all,
I need to return the rows of a table which was also created in that
procedure.
I know it is very easy when the table is existed before and we can
specify like this to return
create function a(integer) returns setof exist_table as $$
But it gives error when the table is also created in the procedure like
below :
create function a(integer) returns setof record as $$
declare
a text;
begin
execute 'insert into a values('asdd');
execute 'insert into a values('affffsdd');
execute 'insert into a values('affsdd');
execute 'insert into a values('ashjgdd');
execute 'insert into a values('asfjfgddd');
---Now i want to return the rows of a
DECLARE
r a%ROWTYPE;
BEGIN
FOR r in SELECT * FROM a
LOOP
RETURN NEXT r;
END LOOP;
RETURN;
END;
END;
$$ LANGUAGE 'plpgsql' ;
ERROR: relation "user_news_tmp2" does not exist
CONTEXT: compilation of PL/pgSQL function "create_user_report2" near
line 22
How to achieve this ?
Thanks & best Regards,
Adarsh
В списке pgsql-general по дате отправления: