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)
Список
Дерево обсуждения
Help trying to write my first plpgsql function... Bjørn T Johansen <btj@havleik.no>
Re: Help trying to write my first plpgsql function... Gnanavel S <s.gnanavel@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... Bjørn T Johansen <btj@havleik.no>
Re: Help trying to write my first plpgsql function... hubert depesz lubaczewski <depesz@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... hubert depesz lubaczewski <depesz@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... hubert depesz lubaczewski <depesz@gmail.com>
Re: Help trying to write my first plpgsql function... Bjørn T Johansen <btj@havleik.no>
On 9/15/05, Bjørn T Johansen <btj@havleik.no> wrote:
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
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 по дате отправления
От: Bjørn T Johansen
Дата:
