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

Поиск

Список

Период

Сортировка

От	hubert depesz lubaczewski
Тема	Re: Help trying to write my first plpgsql function...
Дата	15 сентября 2005 г. 06:32:15
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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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