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@xxxxxxxxxx <mailto:btj@xxxxxxxxxx>> > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
