Re: Returning multiple rowsets from a function

On Mon, Jan 10, 2005 at 14:30:36 -0800,
David Fetter <david(at)fetter(dot)org> wrote:
> Kind people,
>
> I've got an issue that must have come up before. Here's the use case:
>
> Middleware sends in a person_id.
> Back-end returns several rowsets: address, email, phone, each of
> independent, variable length.
>
> How do people usually handle this? I've come up with a horrible hack
> involving ARRAYs, but there has to be another way. Jan mentioned
> doing something with REFCURSORS, but I'm not sure how those and this
> problem might connect.
>
> Are there standard ways to do this? If so, what might they be? Some
> code or doc examples would be great. :)

If it is OK to treat these as strings you could make one result set
by using union and probably adding a marker column so the app knows
what type each row is.