Re: Help trying to write my first plpgsql function...

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Help trying to write my first plpgsql function...
Дата
Msg-id 9e4684ce050915023213c1bf2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Help trying to write my first plpgsql function...  (Bjørn T Johansen <btj@havleik.no>)
Ответы Re: Help trying to write my first plpgsql function...
Список pgsql-general
On 9/15/05, Bjørn T Johansen <btj@havleik.no> wrote:
But this function does not do what I need it to do... I want x rows returned, but
instead I just get a stringname...
Either how do I use this name or how do I return x rows?

for refcursors - just use returned name in subsequent "FETCH FROM <this_name>";

for set returning functions you have to declare them as "returns set of SOMETHING"
and then use return next SOMETHING;
insetead of return.

read the docs - it's quite good reading.

depesz

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