Обсуждение: pl/pgsql FOR LOOP with function

Поиск
Список
Период
Сортировка

pl/pgsql FOR LOOP with function

От
"David Legault"
Дата:
Hello,

How can I return the contents of the row object without knowing the names of the parameters in it ? I'd like to do something like row[1] or something similar. Or is there a way to actually get the values knowing the return type but not the name?

FOR row IN SELECT * FROM getgroups(usr) LOOP
   
        .. snip ..

END LOOP;

when

FUNCTION getgroups(usr name) RETURNS SETOF name AS

Thanks

David