cursors and for loops?

Поиск
Список
Период
Сортировка
От Dennis
Тема cursors and for loops?
Дата
Msg-id courier.4078D0C7.00000C8F@wolverine.lercnetworks.com
обсуждение исходный текст
Ответы Re: cursors and for loops?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello, 

I am wondering if I can use a cursor in a for loop. I haven't been able to 
get it to work. I am just beginning plpgsql and I am struggling here. 

I am trying to do this: 


create or replace function ttest(varchar)
RETURNS varchar AS '
DECLAREparId    ALIAS FOR $1;      dennis varchar;      tmp_xvalues RECORD; 
attrVals        CURSOR (thePar varchar)    IS select '' '' || name ||''="''|| value ||''"'' as rval        from attbl
whereidcol = thePar;
 
BEGIN 
OPEN attrVals(parId); 
      for tmp_xvalues in fetch all from attrVals loop          dennis := dennis || tmp_xvalues.rval;      end loop; 
return dennis;
END;
' language plpgsql; 

If I try to use this function like so: 

select ttest('blah') 

I get:
Error: ERROR:  syntax error at or near "all" at character 15 

I guess I am confused what I can put in "for var in <expression> loop" and 
what "fetch next" or "fetch all" evaluates to. 

Dennis
pg-user@calico-consulting.com


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bret Hughes
Дата:
Сообщение: trigger/for key help
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: trigger/for key help