Re: Returning multiple rowsets from a function - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Returning multiple rowsets from a function
Date
Msg-id 20050111162818.GA4797@wolff.to
Whole thread Raw
In response to Returning multiple rowsets from a function  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Mon, Jan 10, 2005 at 14:30:36 -0800, David Fetter <david@fetter.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.


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: IBM releases 500 patents
Next
From: Bruce Momjian
Date:
Subject: Re: RC5 Bundled ...