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

Yes, I did and I found an answer... :)

But I am trying to use this function in a report designer and the result from the
select is in the way of the real data from the fetch... Is there a way around this?


BTJ

hubert depesz lubaczewski wrote:
> On 9/15/05, *Bjørn T Johansen* <btj@havleik.no <mailto: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