Обсуждение: plpgsql : adding record variable to table

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

plpgsql : adding record variable to table

От
thomas veymont
Дата:
hi,

say I have the following (simplified for discussion) pl/pgsql function:

FUNCTION myfunction ( ...)  RETURNS TABLE ( elem1 integer, elem2 text, ...)
DECLAREg RECORD
BEGIN FOR g in SELECT colum1, column2 FROM someTable   LOOP