Re: Help trying to write my first plpgsql function... - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Help trying to write my first plpgsql function...
Date
Msg-id 9e4684ce050915023213c1bf2@mail.gmail.com
Whole thread Raw
In response to Re: Help trying to write my first plpgsql function...  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Help trying to write my first plpgsql function...
List 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 by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: Help trying to write my first plpgsql function...
Next
From: "nicolas.hafner"
Date:
Subject: Copy DataBases Server to server